Excel 2000 character filtering

[westma]

Hello,
I have a column of numbers, but each number has a comma at the end of it. I would like to be able to do calculations with these numbers, but they don't work with commas. Is there any way to format the column of data or run a filter or something to remove or ignore the commas?

 

[SkipVought]

Hi,

Edit/Replace -- and replace a comma with nothing.

;-)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[xlbo]

To REMOVE
Select Data
Edit>Find
Select partial match and ","
Replace with nothing
et voila

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[Dreamboat]

Why not select the column, hit Ctrl+H, type a comma into the Find what box, and don't put anything in the replace with box, and hit Replace all? That should get rid of all the commas. Now, you can format those cells appropriately. It sounds like they're text.

If they still won't calculate properly for you, you may need to do this fix:

Select any blank cell and hit Copy.
Select the *bad* numbers, hit Edit-Paste special, Add.

That forces Excel to see the values as numbers and not text.

Anne Troy
Killer Coder Live Chat!

http://www.vbaexpress.com/forum/showthread.php?p=2121

 

[westma]

Thanks guys, that's what I was looking for.

 

[Dreamboat]

Geeze. I didn't see you guys' replies. We must have REALLY posted all at once!

Anne Troy
Killer Coder Live Chat!

http://www.vbaexpress.com/forum/showthread.php?p=2121