how to remove separators from numbers

L

lata

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
 
M

Mike H

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
 
E

Earl Kiosterud

Lata,

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

John Mansfield

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