Re: autocorrect

Giganews Newsgroups
Subject: Re: autocorrect
Posted by:  Roger Govier (rog…@technologyNOSPAM4u.co.uk)
Date: Mon, 29 May 2006

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" <notrace2004.28k5fe_1148887230.2958@excelforum-nospam.com>
wrote in message
news:notrace2004.28k5fe_1148887230.2958@excelforum-nospam.com...
>
> 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?action=getinfo&userid=34817
> View this thread:
>http://www.excelforum.com/showthread.php?threadid=546374

Replies

None

In response to

autocorrect posted by notrace2004 on Mon, 29 May 2006