How can I get Excel 2003 to display dates before 1900

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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
how do i enter a date before jan 1, 1900 into excel? 1
Date format pre-1900. 1
date formt in Excel 1
MS Excel should handle dates before 1900! 3
FORMAT A CELL TO USE MO/DATE WITH NO YEAR:,DISPLAYS 1900? 2

Back
Top