autocorrect
 

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

autocorrect
 

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"
wrote in message
...

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