need help creating AD/BC date format

[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)

 

[Norman Harker]

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/