Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent Excel from changing numbers into dates? | Excel Discussion (Misc queries) | |||
Is there a way to prevent Excel from automatically formatting data | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
Prevent excel changing numbers data to dates. | Excel Discussion (Misc queries) |