Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I prevent Excel from auto-correcting the date format?
I am using Excel, and every time I enter 2/1 in the spreadsheet - it corrects
it to Feb-1. How do I prevent it from doing this? |
#2
|
|||
|
|||
One way is to format the input column / range as Text first
(via Format Cells Number tab Text OK) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Watts" wrote in message ... I am using Excel, and every time I enter 2/1 in the spreadsheet - it corrects it to Feb-1. How do I prevent it from doing this? |
#3
|
|||
|
|||
Another way is to start with a leading apostrophe:
'2/1 Watts wrote: I am using Excel, and every time I enter 2/1 in the spreadsheet - it corrects it to Feb-1. How do I prevent it from doing this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto arrange the worksheet in a excel 2002 file? | Excel Worksheet Functions | |||
How do I auto increment cell value on print in Excel | Excel Worksheet Functions | |||
How can I stop Excel from correcting data in a sp.sheetfor instan. | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
auto save in office excel 2003 | Excel Discussion (Misc queries) |