I have a macro to input a date in Excel as follows :

ActiveCell.Value = InputBox("Enter date (DD/MM/YYYY)")

The active cell is formatted as custom dd/mm/yyyy

However if I enter 12/08/2004 it stores it as 08/12/2004 whereas if I
enter 13/08/2004 it enters it correctly in both the cell and the
formulae bar.

I don't know if its relevant but I have my regional settings set to UK
but the options for date settings in excel are all US, which is why I
had to use custom. I expected these to provide UK options or is this a
red herring.

System is XP Pro using O2K.

Thanks John