View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pat[_24_] Pat[_24_] is offline
external usenet poster
 
Posts: 3
Default 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