How to Format Currency?

[harrynguyen2000]

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!

[dougperez]

Hello!

See the workflow attached.

[vsoni]

this should do the trick

[sparksun · Accepted solution]

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

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