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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

group by and count null values 6
Cell Formatting 2
Date changes in data 1
date formattin 5
Date mm/yy 2
Converting date format 4
Changing Date for Pivot Table Result 2
Custom footer date format 2

Back
Top