stop number to date conversion

J

jeffrey

is there a switch (i haven't been able to find one) for turning off
automatic number to date conversions? currently i have to keep all cells
formatted to text, to avoid this, and not have 1-2 turn into jan 2. or
having to remember to type apostrophe before. i'd rather leave format
default to general, except for the annoying date conversion.

is there any way to stop this behaivor?
 
D

Dave Peterson

There's no setting.

You could change the format to Text, but that ain't general.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Revision conversion to a number suggestions ? 3
how to stop auto converting number to date? 5
import csv without automatic date conversion 1
Stop text to date conversion 1
Stop numbers converting to dates. 2
Is it possible to get Excel to stop formatting text as a date? 2
show to stop scientific numbers from general formating 1
stop outlook minimising letters after a date number like 7th 2

Top