Format dates

S

steven

Hello,

I would like to format a dates in column A to a specific format (either
directly in column A or column B)

The format is ddmmy. So for example 18/1/2006 should appear as 18016 and
3/12/2006 should appear as 03126. Is there a way to do this?

Using "format cells/date" wont do the trick. Any suggestions please?

Thank you,

Steven.
 
B

Biff

Hi!

Use a CUSTOM format of ddmmy.

Select the cells
Goto Format>Cells>Number>Custom
In that little box on the right type: ddmmy
OK out

Biff
 
S

steven

This won't work. Have you tried this? Does it work for you?

Cause if I use a custom format ddmmy it displays it like ddmmyy. Also FYI if
I use a custom format ddmmyyy it displays it as ddmmyyyy.

Any other suggestions?

S.
 
B

Biff

Ooops!

Yes, I did try it but must not have noticed the yy.

I'm not sure how to do this and have the date serial number still be the
same.

Biff
 
D

Dave Peterson

=TEXT(A1,"ddmm")&YEAR(A1)-10*INT(YEAR(A1)/10)


Hello,

I would like to format a dates in column A to a specific format (either
directly in column A or column B)

The format is ddmmy. So for example 18/1/2006 should appear as 18016 and
3/12/2006 should appear as 03126. Is there a way to do this?

Using "format cells/date" wont do the trick. Any suggestions please?

Thank you,

Steven.
Click to expand...
 
Top