Sign in with
Sign up | Sign in
Your question

Remove comma

Last response: in Windows XP
Share
January 20, 2011 3:03:30 PM

Hello,
I know this will be simple, but How do I remove a comma from all of the prices in a column. They are numbers in text format. I have tried changing the format but I can only do one at a time. I just need all of the numbers to go from this 345,500 to this 345500, please

More about : remove comma

January 20, 2011 3:08:35 PM

If you mean the coma in a column on a spread sheet you should be able to click on the entire column. for example if it is Column C you would just need to click on C at the top, the entire column should highlight and then you apply your format changes and it changes the entire column.
m
0
l
January 20, 2011 3:43:56 PM

If you're in a spreadsheet, highlight the column, as mentioned above, right click, and choose format. Then change it to a 'text' format.

If you're in a word document, just do a 'find and replace.' Put your , in the find box, and leave the replace box empty.
m
0
l
Related resources
January 27, 2011 9:09:41 AM

Does not work
m
0
l
January 27, 2011 9:16:21 AM

This works:
Try selecting the column and go to Data|Text to Columns... just Click Finish.

Then while still selected, right-click select Fomat Cells and in the Number tab, select General

m
0
l
!