Changing Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If you format the column as text before entering the date, it should stay as
text.
 
Back
Top