Hi

You may try to use 1904-year system (from menu: Tools.Options.Calculation),
but there is a lot of disadvantages - you have to convert your existing
dates, maybe some date functions don't work properly (especially with
negative dates), etc.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



"Folke Günther" wrote in message
...


"Arvi Laanemets" wrote:

Hi

For such interval, your times are probably years. When yes, then you can
simply use numeric year values instead of dates.

To convert a date to year number, use the formula (with date p.e. in
cell
A2)
=YEAR(A2)
and format as General
It didn't work. XL returned everything below 1 AD as 'invalid', and year
1
as '1900'

Do you have another method to make XL understand that there was a time
before 1900?

FG