From: shank on
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
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