Global Annual Date Change

acmoseley

New Member
Joined
Jul 11, 2005
Messages
24
Somewhere in Excel there is a setting for global date ranges. Right now in Excel if you enter the date 2/2/26 it defaults it to 2/2/2026 and if you do a date for 2/2/36 it defaults to 2/2/1936.

Does anyone know where that setting is so that I can change it?

Thanks,
Andrew
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
It's not in Excel, but Windows. Click Start|Settings|Control Panel|Regional Options and increment the year under Calendar on the Date tab.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,660
Members
412,481
Latest member
nhantam
Top