How to stop date in cell

  • Thread starter Thread starter Leef
  • Start date Start date
L

Leef

Microsoft Excel for XP (2002, I believe)
Hi,
I'm a simple user of this program, but I cannot figure out how to STOP Excel
from changing my input to a date. I am trying to do a chart of yarn setts,
and when I type into the cell "12/2" (without quotes), and hit the tab to
move to the next cell, Excel continues to change my input to Dec 2. How do
I stop it from automatically changing my input to a date? The data I am
referencing is NOT dates!

Any help would be MOST appreciated!

Sincerely,
Leef
 
Leef wrote...
....
I'm a simple user of this program, but I cannot figure out how to STOP Excel
from changing my input to a date. I am trying to do a chart of yarn setts,
and when I type into the cell "12/2" (without quotes), and hit the tab to
move to the next cell, Excel continues to change my input to Dec 2. How do
I stop it from automatically changing my input to a date? The data I am
referencing is NOT dates!
Click to expand...
....

No way to stop Excel from doing this other than to change entry cells'
number format to Text or precede all such entries with an
apostrophe/single quote.
 
I'm constantly entering yarn counts, in relation to dye formula revisions
between a 10\1 and a 50\1 jersey.

You should notice what I entered above!

Just use the *backslash*.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top