formating decimals

Hi, I got money types coming out of the db.
I use #,##0.## all is swell 14.1400 comes out as 14.14,
14.0000 comes out as 14
but then I get 0 or 0.00, it comes out 0.00
I want it to be just 0
ThanksI would compare the value with what you consider a small enough value to be
taken as zero and use the appropriate formatting
iif(abs(dbvalue) < 0.0001, "0", "#,##0.##")
Andrei.
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1115831567.239111.316890@.o13g2000cwo.googlegroups.com...
> Hi, I got money types coming out of the db.
> I use #,##0.## all is swell 14.1400 comes out as 14.14,
> 14.0000 comes out as 14
> but then I get 0 or 0.00, it comes out 0.00
> I want it to be just 0
> Thanks
>