Thread: Format Currency
View Single Post
  #1   Report Post  
Send Object Command - Two attachments
 
Posts: n/a
Default 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 -