making excel recognize it's 20XX not 19XX

[daveyc18]

is there a simple way to do this so that it's not PC dependent ? change the settings within the workbook? rather not use formulas

 

[Rick Rothstein]

There is a Windows setting to handle this.

They certainly buried it deep enough.

They certainly did bury it deep; however, the OP said in his opening post that...

is there a simple way to do this so that it's not PC dependent ?

 

[daveyc18]

There is a Windows setting to handle this.

Click Control Panel > Time & language > Under "Related settings" on the right: Additional date, time, & regional settings > Change date, time, or number formats > Additional settings > Click the Date tab > and in the Calendar section, scroll the number until it says 2099.

They certainly buried it deep enough.

thanks for the rpely.

ya i looked into this, but isn't this PC dependent? if my colleague opens this workbook on her PC, it would stills how 12/30/1945 for instance, right?

NVM: Rick's post above confirmed.

 

[Rick Rothstein]

ya i looked into this, but isn't this PC dependent? if my colleague opens this workbook on her PC, it would stills how 12/30/1945 for instance, right?

No, if you entered a date and the code "corrected" it for the year, your colleague's computer would show the corrected year (2045); however, if your colleague put a date into the worksheet using her computer, it would not auto-correct.