How do I enter BC dates in Excel?

[Joe H]

How does one enter a "BC" date in Excel - such as March 3rd, 1450 BC?

 

[Per Jessen]

Hi

Select the cell(s), goto Format > Cells > Number > Select Cusom > Type :
mmmm dd, yyyy BC > OK

Hopes this helps.

 

[David Biddulph]

But March 3rd, 1450 would not be a valid Excel date, so that formatting
doesn't work.

And of course the month and day system was very different if you go that far
back in time.

 

[Fred Smith]

Excel does not handle dates prior to 1900 AD without special addins.

Unless you need to work with the dates, just enter them as Text.

Regards,
Fred.