computing
  • 0

Excel: Chge ‘Input’ Date Format MM/dd dd/MM

  • 0

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

Share

1 Answer

  1. Excel uses the settings found here:

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

    • 0