How to prevent Excel from formatting Dates ?
I am pasting the following cell into Excel, and I'd like Excel to NOT try to
format it as dates:
08/03/2006
Excel's default behaviour seems to be "oh, this looks like a date, I'll
screw up the formatting", and I end up with 08-03-06 in my cells.
How can make sure that whatever I paste, Excel will be nice enough and just
consider it all text, no matter if it looks like a date or not.
(The only workaround I have is to paste in Notepad, and the use the import
wizard in Excel to set each column to text. A pain in the ***)
Thanks for any help
|