I think that you'll find that this is a setting that travels with the
workbook--not the user.
So you'd have to check that workbook--on any user's pc.
KR wrote:
We have checked both users' PCs, and neither user had the 1904 date box
checked. Unless there is anything else I can check, this one may get chalked
up to a great mystery of life...
"Dave Peterson" wrote in message
...
Just to add to Bernard's post...
Saved from a previous post:
One workbook was using a base year of 1900 and the other was using 1904.
(tools|options|calculation tab|1904 date system)
<snip
KR wrote:
Situation:
<snip
The fact that the dates are about 4 years off (taking into account leap
year, it probably matches up exactly) makes me think of the Macintosh
seed
date being 1904 instead of 1900...but no-one here uses a mac, and if the
date was actually based on the machine date, I would think that the
numbers
would still match up within a PC, and certainly within a worksheet.
Has anyone else come across this? Any idea what would cause it, so we
can
ensure it doesn't happen again?
Thanks,
Keith
--
The enclosed questions or comments are entirely mine and don't represent
the
thoughts, views, or policy of my employer. Any errors or omissions are
my
own.
--
Dave Peterson
--
Dave Peterson
|