Forum Discussion
Stop Excel to interpret date string as dates in text formatted cells
I am really puzzled by the Excel behavior. I have a sheet and I have a column that has format TEXT, so I expect that whatever I put there is interpreted as a string and no attempt is made to guess an...
dejudicibus Copy/Paste or Drag&Drop overwrites everything in the destination cell. Also the format that you had given the cell. Select Paste Special and find the right option to paste. When I tried copying a date from the web into a text formatted cell, Paste Special offered me a number of paste options. On a Mac it says "Keep source formatting" or "Match destination formatting". On Windows, I get "Keep Text Only".
Used to work ... doesnt work
Still get goofy results, trying to paste 12 - 48 "months", ends up Dec -48, except 12-24 ends up 24- Dec. I thought there was an OPTION to select to keep this from happeneing. I cant seem to find how to search OPTIONS . Thats a deal breaker!