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?