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

Hi

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

Hopes this helps.

---
Per

"Joe H" <Joe skrev i meddelelsen
...
How does one enter a "BC" date in Excel - such as March 3rd, 1450 BC?

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.
--
David Biddulph

"Per Jessen" wrote in message
...
Hi

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

Hopes this helps.

---
Per

"Joe H" <Joe skrev i meddelelsen
...
How does one enter a "BC" date in Excel - such as March 3rd, 1450 BC?

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.

"Joe H" <Joe wrote in message
...
How does one enter a "BC" date in Excel - such as March 3rd, 1450 BC?