changing date format

[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

 

[Jason Morin]

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

 

[Frank Kabel]

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