dates

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
 
J

joel

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

Creating a Search using a combo box and then creating a report. 4
Dates before 1900 2
Page sort 0
How to count the numbers in a Word document? 0
Creating Different Headers in Word 0
Insert Index into a Table 1
Date Formats 4
Fields 2

Top