I have a macro to input a date in Excel as follows :
ActiveCell.Valu e = 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