View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elaskel Elaskel is offline
external usenet poster
 
Posts: 2
Default Using Hyphens in a cell

Hello, I am trying to use hyphens in my worksheet. For example, I
would like to enter 6-9 instead of entering 6,7,8,9. But, every time I
enter 6-9, it is converted to 38877.00 for a number designation or
9-Jun like it is a date.

Any suggestions?