| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
howdo I turn off default that automatically changes 8-4 to Aug-4?
When I type 8-4 or 8/4 in a cell, these characters automatically change to
Aug-4 when I move to the next cell. Obviously there is a default at work in Excel 2003 that is doing this. Is there a way to turn off this default or am I forced to contiually text format the cells into which I type characters such as these? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
howdo I turn off default that automatically changes 8-4 to Aug-4?
Type an apostrophe before the 8, or pre-format the cell as TEXT
Vaya con Dios, Chuck, CABGx3 "Don" wrote: When I type 8-4 or 8/4 in a cell, these characters automatically change to Aug-4 when I move to the next cell. Obviously there is a default at work in Excel 2003 that is doing this. Is there a way to turn off this default or am I forced to contiually text format the cells into which I type characters such as these? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
howdo I turn off default that automatically changes 8-4 to Aug-4?
You can set the locale option to English (United States) instead of letting it be custom. -- Intekhab Aalam ------------------------------------------------------------------------ Intekhab Aalam's Profile: http://www.excelforum.com/member.php...o&userid=34171 View this thread: http://www.excelforum.com/showthread...hreadid=539377 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| turn off automatic date default | Setting up and Configuration of Excel | |||
| Setting default font and colour | Excel Discussion (Misc queries) | |||
| Setting a default save folder for a template | Excel Discussion (Misc queries) | |||
| Setting and KEEPING the default chart | Charts and Charting in Excel | |||
| making columns automatically turn numbers into negatives | Excel Worksheet Functions | |||
Linear Mode
