Prev: Inventory Loop
Next: Free Live Voice and Video Chat!Connect with Over 4 Million Members download now
From: shank on 2 Jun 2010 01:20
AMOUNT: CStr([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed])

How do I convert $45.50 to "45.50" ...?
No matter what I do I keep dropping the zero to "45.5"

thanks!


From: Wolfgang Kais on 2 Jun 2010 03:08
Hello.

"shank"
> AMOUNT: CStr([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed])
>
> How do I convert $45.50 to "45.50" ...?
> No matter what I do I keep dropping the zero to "45.5"

AMOUNT: Format([Amazon POs]![Cost]*[Amazon POs]![QtyConfirmed],"0.00")

--
Regards,
Wolfgang


 | 
Pages: 1
Prev: Inventory Loop
Next: Free Live Voice and Video Chat!Connect with Over 4 Million Members download now