| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HI, I want to 5-9 as age group but it comes as 05 sept date forma
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formül Yardımı | Excel Discussion (Misc queries) | |||
| Colorir linhas de forma alternada no excel | Excel Discussion (Misc queries) | |||
| Copying Data forma website | Excel Discussion (Misc queries) | |||
| How to convert the dates from the YY:DD forma to MM/dd/YYYY format | Excel Worksheet Functions | |||
| pro forma | Excel Discussion (Misc queries) | |||
![mastermind[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
