Currency Format

I'd like currency format of $#,###
but when i specify that, I dont get any values for 0 I just get a $
which is somewhat expected.
If I specify C, I get the cents, which I dont care about.
Anyone knowhow I might achieve C currency format, that doesnt include
cents, but displays 0 when the value is 0?
Thanks in advance
Weston WeemsWeston,
Check out the FORMATCURRENCY function.
HTH
Jerry
"Weston Weems" <wweems@.nospam_itsucksGMAIL.COM> wrote in message
news:uFR4buHxFHA.664@.tk2msftngp13.phx.gbl...
> I'd like currency format of $#,###
> but when i specify that, I dont get any values for 0 I just get a $ which
> is somewhat expected.
> If I specify C, I get the cents, which I dont care about.
> Anyone knowhow I might achieve C currency format, that doesnt include
> cents, but displays 0 when the value is 0?
> Thanks in advance
> Weston Weems