Tired of excel reformatting entries into dates

[vangogh228]

If I enter 2-4 into a cell, as in "pages 2 through 4," excel reformats it as Feb 4. I don't want that to happen. Yes, I know I can use an apostrophe. I don't want to have to do that. How can I turn this irritating helper... just one of many... OFF?

Thanks!

 

[KeithG]

Change the cell format to text.

 

[vangogh228]

Tried that before. Does not work.

Any other help?

 

[rainman89]

did you change it to general? i know we had the problem and thats what fixed it

 

[vangogh228]

Tried that too. Same old thing.

Thanks for any help...

 

[rainman89]

you sure formating as text doesnt work. i just tried it (2003) and it worked for me....