When can we stop assuming that a 2 digit year starts with 19

1. What does a 2-digit year mean?
2. How do I convert a 2-digit year to a 4-digit year in Excel?
3. How do I get a two digit year in Excel?
4. How do you put 2 numbers in a year?

What does a 2-digit year mean?

If the 2-digit year is greater than or equal to 40, the century used is 1900. In other words, 19 becomes the first 2 digits of the 4-digit year. If the 2-digit year is less than 40, the century used is 2000. In other words, 20 becomes the first 2 digits of the 4-digit year.

How do I convert a 2-digit year to a 4-digit year in Excel?

We can just open the Format Cells dialog by pressing Ctrl + 1. After that select the Custom category on the Number tab, and enter one of the codes below in the Type box: yy – to display 2-digit years, as 00-99. yyyy – to display 4-digit years, as 1900-9999.

How do I get a two digit year in Excel?

Click Start, point to Settings, and then click Control Panel. Double-click the Regional Settings icon. Click the Date tab. In the When a two digit year is entered, interpret a year between box, type the cutoff year that you want, and then click OK.

How do you put 2 numbers in a year?

According to this source the correct symbol to abbreviate year using two digits is an apostrophe: When abbreviating a year, remove the first two numbers and indicate the omission by using an apostrophe: 2009 becomes '09 (not '09) 2010 becomes '10 (not '10)