How to change my numbers sheet to convert commas to decimal.

You need to set the commas to dots and the dots to commas so it is not a single find/replace, even if you use SGIII's "Find & Replace in Selection" shortcut. Using the shortcut (or the regular Find/Replace if there are no other commas or dots in the spreadsheet), you would need to change the dots to some other character, the commas to dots, then that other character to commas. After that you may need to set the format to number.

Or you can use the built-in tools. You said the language was correct, how about the region?

1. Set the column to "text".
2. Look to be sure the numbers are all correct. When importing numbers from one region into a spreadsheet set to another, some numbers might get misinterpreted. 12.345,67 might be treated as text (which is okay, we can fix that) but 12.000 or 12,000 might be twelve thousand when it was supposed to be twelve, or vice versa.
3. Set the region (File->Advanced->Language & Region) to one that uses the format of the numbers in that column. Bolivia is one.
4. Change the column to "number"
5. Set the region to one that uses the 123,456.78 format. United States is one. Maybe the default System-Language is also one.

Try using Find and Replace to manually change the comma to a decimal. Selecting a currency didn't seem to work for me. Just be careful with commas being used in other columns.

stephaniecogs wrote:

3300000.00, when I need 33,000.00

Did you click the checkbox before Thousands Separator?

SG

The numbers should have had decimals, you should not have had to do this. What did the number look like before you formatted it for two decimals? It appears it had no decimal (i.e, it was 3000000 with no decimal point in it). Did you follow the region changing method or did you do find/replace to fix the numbers?

If the numbers are all like the 3000000, create a temporary new column and divide all of them by 100. Copy and Paste Formula Results (not the standard Paste) the results back to the original column then delete the temporary column.

With the number selected (it should now be right-aligned by default) have you gone to Data Format in the Cell tab of the right sidebar and set Decimals: to 2?

SG