unchecking 1904 date system for all excel files

External Since: Jun 13, 2007 Posts: 3

I discovered that the dates were off on my excel files, and that I
need to uncheck the 1904 option in the preferences.

However, I am wondering, if there is a way to do this for all of the
excel documents I have, instead of having to go to every one
individually.

External Since: Feb 11, 2005 Posts: 578

On 6/28/07 12:55 AM, in article
1183006554.329123.207090 DeleteThis @k79g2000hse.googlegroups.com, "lyh1124@gmail.com"
<lyh1124 DeleteThis @gmail.com> wrote:

> I discovered that the dates were off on my excel files, and that I
> need to uncheck the 1904 option in the preferences.
>
> However, I am wondering, if there is a way to do this for all of the
> excel documents I have, instead of having to go to every one
> individually.
>
If the workbooks already exist, you will have to do it manually for each
one. Yu could, of course write a short Vba routine to do it for you. Simply
unchecking the box will shift the date by 1462 days. You may then also have
to apply this correction to get the dates correct in the other system.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom