Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I transfer the autocorrect options from work to home? | Excel Discussion (Misc queries) | |||
Is there a way to increase the AutoCorrect limit in Excel 2003? | Excel Discussion (Misc queries) | |||
how do i copy autocorrect options? | Excel Discussion (Misc queries) | |||
Problem - Excel 2003 SP2 - Tools / Autocorrect Options.... | Excel Discussion (Misc queries) | |||
COPYING AUTOCORRECT DICTIONARY TO NEW COMPUTER | Excel Discussion (Misc queries) |