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