Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
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. "excelguy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |