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

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

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.
"TKassis" <(E-Mail Removed)> wrote in message
news:EF7291DB-615E-4D64-901B-(E-Mail Removed)...
> 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

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

Vaya con Dios,
Chuck, CABGx3



"TKassis" wrote:

> 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