auto date annoying

S

Sproul

how can you put information like this "19-2" in a field without it being
changed to a date format, I dont want dates.

Al....
 
J

joeu2004

Sproul said:
how can you put information like this "19-2" in a field
without it being changed to a date format
Click to expand...

You can prefix the data entry with an apostrophe ('). I usually
lack the foresight to format the cell as Text before entering the
data. Changing to Text format after the fact results in a number,
the internal value of Excel dates.
 
C

CLR

RIGHT, or just type a leading apostrophe before the string, which does the
same thing.

Vaya con Dios,
Chuck, CABGx3
 
Top