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

"Elaskel" wrote:
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.


Precede the entry with an apostrophe
Or, pre-format the cell as Text
(via: Format Cells Text OK)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---