In excel when inputting dates 10/4/04 (10/april/04) data converts.

[Guest]

In excel when inputting dates 10/4/04 (10/April/2004) excel converts this to
4/10/04 (4/October/2004) Where can I change the input characteristics.
I have changed the date format to English (UK) and this works when I input
the date in the American format mm/dd/yy but I want to input in the dd/mm/yy
format

 

[Dave Peterson]

I think I'd try chaning my windows regional settings.

In win98, I'd get to it via:
Windows start button|Settings|control Panel|regional settings applet
Date Tab

Change the short date format to dd/mm/yyyy (I like 4 digit dates--you don't have
to use that part--but put it in dmy order.)

This affects other programs--so keep an eye out.