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?

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?

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