How can I get Excel 2003 to display dates before 1900

G

Guest

I work with an Access database of baptisms, burials and marriages dating from
1500. When I try to publish results in Excel 2003, the dates befoe 1900 are
displayed with the hash sign as negative dates! How can I format these
results correctly?
 
B

Bob Phillips

Quote from Norman Harker

You can enter dates pre 1900 as text but they wouldn't be treated the same
as 'real' Excel dates. Just prefix the entry with a '


Alternatively, John Walkenbach has a free download Extended Date Function
Add-In that allows dates from 1-Jan-400 to 31-12-9999 and those functions
allow the various calculations allowed by 'normal' Excel date functions.
 
D

Dave Peterson

Excel doesn't support dates before 1900.

Maybe you could force those values to text -- I have no idea how to do that when
retrieving from Access, though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates before 1900 2
how to enter sortable dates before 1900 1
dates before 1900 2
MS Excel should handle dates before 1900! 3
Dates prior to 1900 in Excel 1
how do i enter a date before jan 1, 1900 into excel? 1
Excel having problems with dates earlier than 1900 2
negative dates in excel 1

Top