Excel: chge 'input' date format MM/dd dd/MM

Microsoft Microsoft excel 2007 full vers...
November 5, 2010 at 05:51:02
Specs: Windows XP
Hello,

I know how to change 'output' format of dates on Excel
However,
Does any one know how to change the 'input' format of a date ?

--> i.e. when I enter 5/10/09, the computer understands 10-May-09 instead of 5-Oct-09

thx


See More: Excel: chge input date format MM/dd dd/MM

Report •


#1
November 5, 2010 at 11:31:34
Excel uses the settings found here:

Control Panel
Regional and Language Options
Regional Options Tab
Customize Button
Date Tab


Report •

#2
November 6, 2010 at 02:11:23
thx a lot
best
CH

Report •

Related Solutions


Ask Question