Format Currency
I have a table that contains values that are in a very unique format. The
decimal and comma are incorrect...(Pls don't ask why, file is from Europe...)
The decimal should be a comma and vice versa.
Anyway, I need to know how to format (in a query) in such a way that if
reflects correct currency.
See example:
Currently: Should Look Like:
2.301,44 $2,301.44
2.094,75 $2,094.75
44,72 $44.72
54,32 $54.32
15,96 $15.96
785,63 $785.63
2.356,89 $2,356.89
174,72 $174.72
Can anyone help?
Thanks -
|