How do I turn off the autoformat that converts 1-0 to Jan-00?

Posted to microsoft.public.excel.misc

Josh

Posts: n/a

How do I turn off the autoformat that converts 1-0 to Jan-00?

And all the other number to date stuff. It's getting really annoying having
to go back and change every cells format.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
make it easy to turn off the little paste option graphics	devinmckinney	Excel Worksheet Functions	1	May 24th 06 08:40 PM
How do I turn off autoformat for .CSV (comma delimited) files?	Mike Schwartz	Excel Discussion (Misc queries)	1	February 2nd 06 09:08 PM
How can i get autoformat name of range in excelsheet?	classpeople	Excel Worksheet Functions	0	June 22nd 05 03:16 PM
How do I turn off ALL autoformat in Excel ? (I can't even type "J.	Dave a.k.a. Technophobe	Excel Worksheet Functions	2	February 23rd 05 01:46 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM

All times are GMT +1. The time now is 02:42 AM.

About Us