To change the system given by 1900 to 1904 and vice versa on Excel5 min read

PRECONDITION

This guide is born for provide some explanations on as to change the dates inside a file Excel from a system of date 1900 to a 1904 and vice versa, also providing file of example to help its understanding (after all to the article).

DIFFERENCE BETWEEN THE TWO DATE SYSTEMS

In a system of date 1904, the first day that can be inserted corresponds to 1° January of the 1904. The date that inserted it is converted in a number seriale that represents the number of days had spent since 01/01/1994. If we for example format the cell as date, inserting the number 0 will be converted in 01/01/1904 or the the first date that recognizes. This system has been projected since in the first computers Macintosh the preceding dates to 01/01/1904 were not supported. This has been projected to avoid problems related to the fact that 1900 have not been one leap year. If he passes to the system it dates 1900, Excel for Macintosh supports dates that go up again to January 1° 1900.

In the system of date 1900, the first supported day is January 1° 1990. Also in this case the date is converted in a number seriale that corresponds to the number of days had spent since January 1° 1900. if on it inserts the number 0 it will be converted in 00/01/1990 and so street for all the numbers.

SYSTEM PROCEDURE 1900 TO 1904

In the case in which we wanted to have changed the system since 1900 to 1904, we should go under File – > Options – > Advanced Formulations – > When calculating this workbook – > to Select uses date system 1904. You don’t worry you if there will be one day in more in our column of the dates. We now select the whole column in which the dates are been inserted, right click and you insert. In this way a new column will be inserted really of side to the selected one. We select the first blank cell and we write = now we select the first cell in the column of the dates to modify, we insert a -1462 and we give dispatch (the number 1462 exactly correspond to the number of days that separates the dates among the two systems). We select the modified cell and let’s copy it with the cross up to where we want, copying the formula in the other cells getting all the modified dates. To conclude we copy the whole new column and we glue it as solo values. We can now cancel the old column and we will have gotten the changed dates.

SYSTEM PROCEDURE 1904 TO 1900

In the case in which we wanted to have changed the system since 1904 to 1900, we should go under File – > Options – > Advanced Formulations – > When calculating this workbook – > Deselect uses date system 1904. you don’t worry you if there will be one day in less in our column of the dates. We now select the whole column in which the dates are been inserted, right click and you insert. In this way a new column will be inserted really of side to the selected one. We select the first blank cell and we write = now we select the first cell in the column of the dates to modify, we insert a +1462 and we give dispatch (the number 1462 exactly correspond to the number of days that separates the dates among the two systems). We select the modified cell and let’s copy her/it with the cross up to where we want, copying the formula in the other cells getting all the modified dates. To conclude we copy the whole new column and we glue her/it as solo values. We can now cancel the old column and we will have gotten the changed dates.

CONCLUSION

It is important to remember that the changes on the file are only real in the pc in which they have been effected. If we for example send the file to another computer that has however selected a system it dates different from ours, this last will see the gives according to his system it dates and not according to ours planned. In this case or it goes to modify the advanced formulations on options or to follow the illustrated procedures in precedence.

LINK: DOWNLOAD

Recent Tweets

For privacy reasons Twitter needs your permission to be loaded.
I Accept
2018-08-27T07:02:52+00:00

About the Author:

Doctor in Computer Science, I've always been passionate about computers and their operation. In these last years I have decided to specialize me in the system field focusing my studies on the network and the servers. Together with Daniel, I have decided to create this blog to help, through of the guides, more possible people trying to transmit to them our passion.

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.