I am trying to have a user type for example: 1/2/3 meaning 1st Feb 2003, and have Excel automatically convert it to 01/02/2003. However when I select the custom date option: dd/mm/yyyy in the format cells window, in the formula bar is 02/01/2003, the American format.
How can I get both displayed dates to read 01/02/2003 or alternatively 01/02/03.
Thanks,
Richard
How can I get both displayed dates to read 01/02/2003 or alternatively 01/02/03.
Thanks,
Richard