Replacing comma in numbers with decimal

[devonkrusich]

I am working with an 11000 row spreadsheet and all of the rows in one column have a comma where a decimal should be. For example 6,54 instead of 6.54. How can I replace the comma with the decimal without manually changing it in each row?

Also I have another column that has descriptions in each row. Some of the descriptions begin and or end with weird text. Like. $%@@&L. Is there a way I can highlight the entire row and only remove the strange characters?
thanks.

 

[stanleydgromjr]

devonkrusich,

I am working with an 11000 row spreadsheet and all of the rows in one column have a comma where a decimal should be. For example 6,54 instead of 6.54. How can I replace the comma with the decimal without manually changing it in each row?

Click on Tools, Options, International tab, change the "Decimal separator:" to ".", and the "Thousands separator" to ",", then click on "OK".


Have a great day,
Stan

 

[Peter_SSs]

I am working with an 11000 row spreadsheet and all of the rows in one column have a comma where a decimal should be. For example 6,54 instead of 6.54. How can I replace the comma with the decimal without manually changing it in each row?

Also I have another column that has descriptions in each row. Some of the descriptions begin and or end with weird text. Like. $%@@&L. Is there a way I can highlight the entire row and only remove the strange characters?
thanks.

devonkrusich

Welcome to the MrExcel board!

First issue:
Depends just what is in that problem column, but try this:
1. Select the column by clicking its heading label.
2. Edit|Replace...|Find what: , |Replace with . |Replace All

Second Issue:
Much harder unless there is some uniformity with what is happening. Can you give us say 5 or 10 examples of what is in that column as well as what you want to end up with in that column?

 

[Claymationator]

You could also do a Find > Replace.

Select the range that you want to replace the "," in and then press CTRL + F and that will bring up the find function. Click the Replace tab and then put in a "," in the Find What field and a "." in the Replace With field, then press Replace All.

This will go through the range and replace the comma with a period.

Hope that helps.


Looks like PeterSS beat me to it.