Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|