David McAfee
davidmcafee at gmail.com
Thu Aug 21 12:17:57 CDT 2014
I know this question should really go to Excel-L rather than Access-D, but you're all a smart bunch so I figured I'd ask here first. ;) A pet peeve of mine is pasting data from and Access Query or SQL Server Management Studio into Excel and the data is wrapped and dates always show up weird. I don't remember this occurring before Office 2007 (but I can't remember past last weekend much less 7 years ago). So every time I paste a big grid of data, I have to toggle "wrap text" three times. If I choose "Short Date" from the formatting drop down in the number toolbar (in the ribbon) the dates will change to short dates. If I past the same (or different) data from the clip board it reverts back, losing the short data and non wrapped text formatting. Am I silly to think it didn't work this way in earlier versions? Thanks, David