View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Would like to display 1-30 in cell

pre-format as text or use ' before

--
Don Guillett
SalesAid Software

"Hank" wrote in message
...
Typing in the term 1-30 in a cell always returns the date Jan-30. I
understand date formatting but I would like to display the term 1-30. The
next cell is 31-60 and displays properly. How do I do this. Thankyou.