how to remove separators from numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to remove separators form range of numbers for example
2,565,275.45 as 2565275.45
145,652,835.65 as 145652835.65
25,256,189.50 as 25256189.50
 
how to remove separators form range of numbers for example
2,565,275.45 as 2565275.45
145,652,835.65 as 145652835.65
25,256,189.50 as 25256189.50
Click to expand...

Format as General, Number (without thousands separator), or Custom as
0.00
 
Lata,

If these are really numbers (not text), just change the number formatting.
Format - Cells - Number.
 
Lata,

If the numbers are really text, you can remove the commas by selecting your
range of data, going to the standard toolbar and hitting Edit -> Replace.

On the Replace tab, enter a comma in the "Find What" option.

Leave the "Replace with" option blank.
 
You must log in or register to reply here.

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

Separate Cells 2 2
How can Enter Page Numbers and/or page ranges separated by commas. 1
Date separator 1
number separation in excel 2
separate numbers from text 4
Excel Convert word into numbers and back 4
Extracting numbers and letters in a single cell to separate cells 1
How to separate contents of one cell into multiple horizontal cell 1

Back
Top