Thread: If I wanted 5-7 to mean May 7th, I would type "May 7th"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bondi
 
Posts: n/a
Default If I wanted 5-7 to mean May 7th, I would type "May 7th"
Hi,

A workaround would be to format the cells as Text (Right click cell -
Format Cells - Number and chose Text) If you do this befor you enter
5-7 then it should stay as 5-7

Regards,
Bondi

Reply With QuoteReply With Quote