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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - HI, I want to 5-9 as age group but it comes as 05 sept date forma (https://www.excelbanter.com/new-users-excel/158628-hi-i-want-5-9-age-group-but-comes-05-sept-date-forma.html)

mastermind[_2_]

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

Sandy Mann

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
...

All times are GMT +1. The time now is 09:10 AM.