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.

Hi!

Use a CUSTOM format of ddmmy.

Select the cells
Goto FormatCellsNumberCustom
In that little box on the right type: ddmmy
OK out

Biff

"steven" wrote in message
...
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.

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.

"Biff" wrote:

Hi!

Use a CUSTOM format of ddmmy.

Select the cells
Goto FormatCellsNumberCustom
In that little box on the right type: ddmmy
OK out

Biff

"steven" wrote in message
...
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.

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

"steven" wrote in message
...
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.

"Biff" wrote:

Hi!

Use a CUSTOM format of ddmmy.

Select the cells
Goto FormatCellsNumberCustom
In that little box on the right type: ddmmy
OK out

Biff

"steven" wrote in message
...
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.

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



steven wrote:

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.

--

Dave Peterson