Changing Date Format

M

mrbalaje

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?
 
D

David Biddulph

If you format the column as text before entering the date, it should stay as
text.
 
Top