View Single Post
  #2   Report Post  
IanRoy
 
Posts: n/a
Default

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.