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.