| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Date Format
I have several date range in one Column. When I enter the date as
22-Aug-2007, it automatically changed to a number starting 39XXXXX. I know I can reformat the date, but there are several other date range in the same column such as 4Q07, 1Q08... and 2007, 2008 etc. Hence I need to have the column format as text to have 4Q07.... Can anyone help me on this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Date Format
If you format the column as text before entering the date, it should stay as
text. -- David Biddulph "mrbalaje" wrote in message ... I have several date range in one Column. When I enter the date as 22-Aug-2007, it automatically changed to a number starting 39XXXXX. I know I can reformat the date, but there are several other date range in the same column such as 4Q07, 1Q08... and 2007, 2008 etc. Hence I need to have the column format as text to have 4Q07.... Can anyone help me on this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the date format | Excel Discussion (Misc queries) | |||
| Changing Date Format | Excel Discussion (Misc queries) | |||
| changing date format | New Users to Excel | |||
| Changing to date format | Excel Discussion (Misc queries) | |||
| Changing Date Format | Excel Worksheet Functions | |||
Linear Mode
