convert currency to string

  • Thread starter Thread starter shank
  • Start date Start date
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!
 
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")
 
Back
Top