Annette,

Select the entire range that you wish to remove the commas from.
Select Ctrl-F to bring up the Find and Replace. Select the Replace
Tab. In Find what: type in a comma and leave the Replace with: empty.
Select Replace All. This will remove all of the commas in you range.
If there are commas you want to keep then don't use this method.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=486876