Convert date to a custom format

If you really mean a Custom Format (i.e. applied to the cells containing the dates), then you can use this format string in the Custom Format dialogue box:

ddmmyyyy":000000"

Hope this helps.

Pete