need help creating AD/BC date format

  • Thread starter Thread starter Tom K
  • Start date Start date
T

Tom K

I'm trying to create a custom number format for displaying
dates in AD/BC format. So far, Excel is telling me that
my code inputs are not valid. What I want is
for "positive" years to appear as "AD ####", and
for "negative" years to appear as "#### BC"

Any suggestions? Thanks.

Tom Kovach
(e-mail address removed)
 
Hi Tom!

Try custom format:

"AD" ####;#### "BC"


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
Back
Top