How do I enter BC dates in Excel?

  • Thread starter Thread starter Joe H
  • Start date Start date
Hi

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

Hopes this helps.
 
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.
 

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

Subtracting AD and/or BC dates 21
Excel Find length of side of triangle in Excel 12
lookup and placeholder function 2
need help creating AD/BC date format 1
multiple match 4
how do I clear #DIV/0!but leave the formula in cell 2
filter and relations between fields 1
to know about a function is exists 4

Back
Top