how to remove separators from numbers

[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

[Mike H]

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

[Earl Kiosterud]

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" <lata@discussions.microsoft.com> wrote in message
news:A75A6395-3CC7-40C2-826F-B13D3B22FF22@microsoft.com...
> 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
>

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

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