dates

  • Thread starter Thread starter excelguy
  • Start date Start date
E

excelguy

I want to write march 22, 3760 BCE in excel. I know dates before 1/1/1900 can
be written as numbers but I don't know how to make the BCE dates into
numbers. Any ideas? thanks
 
Treat the data as a string by putting a single quote finfront of the data.

'march 22, 3760 BCE


Excel doesn't work with negative dates (before 1/1/1900). You get into a
lot of problems with dates before 1900 because the calendar was changed a lot
of times. In the 1700's they actually move the calendar from April to
February because if was still snowing heavly in May and then adding a leap
day to the calendar. the calendar was established in the 1500's and missing
leap days for 200 years the calendar was off 50 days.
 

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
Conditional Drop-down 1
Lookup 2
negative dates in excel 1
is 1900 a Leap Year? 11
Error in Excel date calculations 3
date comparison 2
How to export table from outlook into ms access table? 0

Back
Top