changing date format

  • Thread starter Thread starter Paul G
  • Start date Start date
P

Paul G

I have a series of dates in an excel column that are
in "General" format and appear as yyyymmdd. I want to
change them to appear as yymmdd.

For example, I want 20040805 to appear as 040805. I tried
to set it up as a custom format but it didn't work.

Thanks,

Paul
 
You can't change the date format because Excel is not
recognizing it as date. You'll need to convert with
something like:

=REPLACE(REPLACE(A1,5,,"-"),8,,"-")*1

and then format it as yymmdd.

HTH
Jason
Atlanta, GA
 
Hi
sounds like your dates are actually stored ad 'Text'. Try the following
before changing the format
- copy an empty cell
- select your cells with date values
- goto 'Edit - Paste Special' and choose 'Add'

Now try reformating again
 
Back
Top