turning off auto date


Posted by chris on April 07, 2001 8:09 AM

in excel when ever i type in a set of numbers in a cell (example: 9 - 14 ) then it replaces it with 14 september.

Posted by Aladin Akyurek on April 07, 2001 8:13 AM

Chris

Format the cells in which you enter 9-14 like items as text.

Aladin



Posted by steve on April 07, 2001 8:18 AM

chris, format your cell as text or you can enter it like this "9-14" or (9-14)

steve