I am using Microsoft Project 2003 for an historic timeline, this means historical dates that go back 1000s of years. I realize using ms-project may be overkill, but it is actually the same as a project, but with pre-modern start dates.
I tried doing this in Excel and got it to work after a fashion using my first date as a minus (for ex. -4026). Then I set up a custom format so that it appears as 4026 B.C.E. (B.C.E. represent "anno mundi" or "BC"). I tried adding a spinner control but it's values cannot go below 0, so I can't highlight columns until I get to a positive date. Solved that by adding another row starting from 0.
Nevertheless, it's cumbersome, so I'd prefer to use MS-Project if possible.
Is this possible? Are there any alternatives?
Thanks in advance.