Global Annual Date Change

[acmoseley]

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

 

[Andrew Poulsom]

It's not in Excel, but Windows. Click Start|Settings|Control Panel|Regional Options and increment the year under Calendar on the Date tab.

 

[acmoseley]

Thanks.