Force 4 digit year (sr1)

Topic

New Reply

Is there a way to force Excel to use only 4 digit years?
I am reading in text files that have four digit years but Excel converts them to 2 digits.

Reply | Quote

Replies

Excel dates are actually stored as the number of days since December 31, 1899. If you enter a four digit year, then Excel will convert it to that value. If you enter a two digit year, then Excel will assume the other two digits (what it assumes depends on which version you have), and then convert it to the number of days since 12/31/1899. Excel does not keep the year as either two or four digits.

What you are probably having a problem with is that the default date display format only displays two digits for the year. If you have a cell that contains a date, then you can select that cell, and then select Cells from the Format menu. In the Dialog box, select Date in the category list, and then select the date format you like from the list. There should be at least one with four digit year. If you don’t see a format that you like, then select Custom in the category list and create a format that displays it the way you want (if you don’t know how, tell us what format you want and we can give you the format to get it).

Reply | Quote