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

On Sat, 8 Jan 2005 21:33:02 -0800, lata wrote:

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

Format as General, Number (without thousands separator), or Custom as
0.00
--
Mike H

Lata,

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"lata" wrote in message
...
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

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.

----
Regards,
John Mansfield
http://pdbook.com


"lata" wrote:

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