HI, I want to 5-9 as age group but it comes as 05 sept date forma

S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top