need help creating AD/BC date format

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
[email protected]
 
N

Norman Harker

Hi Tom!

Try custom format:

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


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

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/
 
Top