How to remove comma and decimals from a value
 

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

How to remove comma and decimals from a value
 

Assuming Excel recognizes the data as numeric, just reformat it. Edit
Cells, select the Number tab, choose 0 decimals and uncheck the separator box.
If there not recognized as numbers, you'd first want to convert them: type
a 0 in some random cell, copy it, select your data set and Edit Paste
Special, select Values and Add, then click OK.

"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

How to remove comma and decimals from a value
 

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