How to Format Currency?

I have the Price column (V_String) with different currency formats as below. I want to add decimals and make them all the same (i.e: $1234.00).

I tried ToString([Price],2,1) and also IF Contains([Price], ".") THEN [Price] ELSE ([Price] + ".00") ENDIF but they did nothing.

Does anyone know how to do this? Thank you in advance!

Help

Accepted answers

Slightly change your expression to the following will do the trick.

IF Contains([Price], ".")=-1 THEN [Price] ELSE ([Price] + ".00")

Hello!

See the workflow attached.

this should do the trick

Slightly change your expression to the following will do the trick.

IF Contains([Price], ".")=-1 THEN [Price] ELSE ([Price] + ".00")