| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I remove from excel automatic date function?
I would like to know if its possible to stop the function in excel that
automatically changes numbers such as 2-28-6 into 2/28/2006. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I remove from excel automatic date function?
You can preformat the cell as Text (format|cells|number tab), then do your data
entry. Or you can prefix your entry with an apostrophe: '2-28-6 Need Help wrote: I would like to know if its possible to stop the function in excel that automatically changes numbers such as 2-28-6 into 2/28/2006. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I remove from excel automatic date function?
If you'll admit that it is not actually a number
and will not be used arithmetically, you can format the column as text, or precede the entry with a single quote to make it text by overriding the format temporarily. Otherwise Excel will treat it as a number and it has nothing to do with how you format a cell as that is only to tell Excel that it is a number and describe the format of the display. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Need Help" <Need wrote in message ... I would like to know if its possible to stop the function in excel that automatically changes numbers such as 2-28-6 into 2/28/2006. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove the annoying automatic date formatting in Excel? | Excel Discussion (Misc queries) | |||
| How do I turn off automatic date function in XL? | Excel Worksheet Functions | |||
| How do I remove the automatic help box in Word and Excel? | New Users to Excel | |||
| Annoying automatic date-formatting on import... how to remove it? | Excel Discussion (Misc queries) | |||
| How to remove the automatic date format? | Excel Discussion (Misc queries) | |||
Linear Mode
