How to remove comma and decimals from a value

  • Thread starter Send Object Command - Two attachments
  • Start date
S

Send Object Command - Two attachments

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
 
B

bpeltzer

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.
 
J

Jason Clement

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, ",", ""), ".", "")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Excel does not accept text format! 0
Any way to know the PRECISE indent values? 3
How to remove first comma in a value 8
Use commas as decimal separator 2
Mail Merge - displaying a conditional number of decimals 5
Decimal Points and comma separators 2
How to change default value of comma style 1

Top