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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I keep the 0 at the beginning of a number, ex. 090? 0
correct to the nearest half 1
why does excel change my numbers? 3
how can i determine number of weeks between 2 dates 0
how do i format an excel cell for stopwatch times mm:ss? 0
ERASE THE "NUMBER 1" IN THE MIDDLE OF SPREADSHEET 0
what formula do you use to get the name of a tab? 1
why does excel not recognise row 1 as a header row when sorting? 1

Top