Remove auto date function in cells

[TKassis]

When I type '11/12' for example in Excel 2003 it automatically changes it to
'12-Nov'. How can I remove this function? I tried endlessly to change thing
in 'options' but nothing seemed to work!

Thanks for any help

 

[jkend69315]

Format the cell for text. (This doesn't fix cells you've already typed
in)

 

[Alan]

It always will do that as it sees a date,
try '11/12 the apostrophe will show in the formula bar but not in the cell,
the ' converts it to text,
Regards,
Alan.

 

[CLR]

Pre-format the cells for TEXT, or type a leading apostrophe in front of your
11/12

Vaya con Dios,
Chuck, CABGx3