View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default How do I enter BC dates in Excel?

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?