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

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

Post by RGF2aW » Tue, 07 Sep 2004 10:23:05


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
 
 
 

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

Post by Dave Peter » Tue, 07 Sep 2004 11:48:26

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.



--

Dave Peterson
XXXX@XXXXX.COM