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 -

I would try this:

Select the range to fix
edit|replace
what: . (dot)
with: x
replace all

Then edit|replace once more
what: , (comma)
with: . (dot)
replace all

then finally one more edit|replace
what: x
with: (leave blank)
replace all

Then format the cells the way you want.


Send Object Command - Two attachments wrote:

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 -

--

Dave Peterson