How does one enter a "BC" date in Excel - such as March 3rd, 1450 BC?
P Per Jessen Jan 27, 2009 #2 Hi Select the cell(s), goto Format > Cells > Number > Select Cusom > Type : mmmm dd, yyyy BC > OK Hopes this helps.
Hi Select the cell(s), goto Format > Cells > Number > Select Cusom > Type : mmmm dd, yyyy BC > OK Hopes this helps.
D David Biddulph Jan 27, 2009 #3 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.
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.
F Fred Smith Jan 28, 2009 #4 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.
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.
