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

I know how to change 'output' format of dates on Excel
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


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

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 •

November 6, 2010 at 02:11:23
thx a lot

Report •
Related Solutions

Ask Question