How to stop date in cell

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
 
H

Harlan Grove

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.
 
R

RagDyer

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!
==============================================
 
Top