convert currency to string

S

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"

thanks!
 
W

Wolfgang Kais

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"
Click to expand...

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