autocorrect

[notrace2004]

hi. how can i disable the autocorrect function in excel? i mean everytime i write 4/4 or 5.6 or 12.5 excel corrects it to some date.. i've tried changing the format of the cells to text and it works that way, but i have the same problem when i copy/paste from somewhere else (not an excel document). excel refuses to 'see' the text format of the cells and changes the format to custom. what can i do?

[Roger Govier]

Hi

It's not autocorrect that is doing the change, it is Excel trying to be
helpful and assuming such entries are dates.
Just prefix the entries with a single quote mark '4/4 for example
The quote mark won't display, but it will force the value to be a text
value and taken literally by Excel.
Alternatively, if you form at the cells as Text prior to data entry you
would achieve the same thing.

--
Regards

Roger Govier


"notrace2004" <[email protected]>
wrote in message
news:[email protected]...
>
> hi. how can i disable the autocorrect function in excel? i mean
> everytime i write 4/4 or 5.6 or 12.5 excel corrects it to some date..
> i've tried changing the format of the cells to text and it works that
> way, but i have the same problem when i copy/paste from somewhere else
> (not an excel document). excel refuses to 'see' the text format of
> the
> cells and changes the format to custom. what can i do?
>
>
> --
> notrace2004
> ------------------------------------------------------------------------
> notrace2004's Profile:
> http://www.excelforum.com/member.php...o&userid=34817
> View this thread:
> http://www.excelforum.com/showthread...hreadid=546374
>