Robert Sterbal wrote:
It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)
I'm getting the impression that you think a product for hundreds of millions of users has to work the way you want it to. If it doesn't, the product is bad.
Well for my comment, I actually would like it to do some work with this. I'm not really sure how the clipboard internals looks coming from SSMS for instance and I get that, its been a long time since I coded using the copy paste buffer for any windows api (literally 16 bit windows the last time I read a copy paste buffer with c). But man, the interpretation excel gives to any date looking thing from the copy / paste buffer is baffling, the windows programmers have obviously put much effort into interpreting this into SOMETHING because of what I see get pasted if I DON'T format the receiving cells as text.
Check it out sometime, I'd be curious if anybody knew what the excel programmers were actually trying to do with a date time value to end up with what actually gets pasted, I'm sure somebody smarter than me might have an idea. Do you?
Maybe scientific notation? Internal SQL bit patterns as a representation of date? *shrug* beats the heck out of me LOL
edit: I'd think MAYBE its because of what SSMS pokes into the buffer from an SSMS date column but then why does a text formatted cell then work fine? I remain clueless!