Thread: HI, I want to 5-9 as age group but it comes as 05 sept date forma
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sandy Mann Sandy Mann is offline
external usenet poster
  
Posts: 2,345
Default HI, I want to 5-9 as age group but it comes as 05 sept date forma
Pre-format the cell as Text or preceed the entry with an apostrophe ie '5-9

The apostrophe will not show in the cell.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"mastermind" wrote in message
...




Reply With QuoteReply With Quote