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.