Convert Value from string to curerncy

[awise]

Is there a function that will convert a string value to currency?

I'm working with a sql column that has a data type of char, but that actual data that is being inserted into this column is a currency. I want to be able to perform a summary on the data values in this column. Shipping costs are inserted into an unused field/column that has a data type of char when in reality the value is a currency.
ex: shipping cost of $12.50 gets inserted and then shows up as a string like 12.500000000000.

Appreciate any tips.

Thanks,
Zaw

 

[vidru]

There's a CCur function designed for that. Create a formula:

//@StringToCurrency
CCur({Table.Field})

-dave