If all you really want is to remove the commas and periods (not convert a
string to a number), and the value is stored as text, you can use the
SUBSTITUTE function:

=SUBSTITUTE(SUBSTITUTE(A1, ",", ""), ".", "")


"Send Object Command - Two attachments" wrote:

How can I remove comma's and decimal's from a value using a formula in a query?
i.e. 4,325.00
Result: 432500