how do i get excel to stop changing my input 5-9 to 9-May????
 

i keep entering in the numbers 5-9 and i tried with spaces, 5 - 9 and yet it
still changes it as if it's a date. I turned off the auto correction control
and it still does it. Please help.

Hi, Molly;
Format Cells Number Text
Then enter 5-9.
Regards,
Ian.

"molly" wrote:

i keep entering in the numbers 5-9 and i tried with spaces, 5 - 9 and yet it
still changes it as if it's a date. I turned off the auto correction control
and it still does it. Please help.

Enter an apostrophe first,
'5-9
OR
Pre-format the cells to Text.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"molly" wrote in message
...
i keep entering in the numbers 5-9 and i tried with spaces, 5 - 9 and yet
it
still changes it as if it's a date. I turned off the auto correction
control
and it still does it. Please help.

format the cell as text.
On Sun, 20 Feb 2005 10:21:02 -0800, "molly"
wrote:

i keep entering in the numbers 5-9 and i tried with spaces, 5 - 9 and yet it
still changes it as if it's a date. I turned off the auto correction control
and it still does it. Please help.