Excel can't calculate with my FACS data (i.e. 36.7%), so I tried to convert the procents into decimal numbers. Since nothing changed after I tried to simply change the format of the cells to "decimal numbers", I tried to delete the "%" and than convert the cells into a decimal number. But somehow this does not work for some cells! after I used the replace-command to replace the "%" with nothing, some cells change their value to something else. Can someone tell me why and can someone tell me how I can change all cells at once from "36.7%" to "0.367"?
Thanks in advance.
Jan
Hi Jan Wulf,
You have to define the format for your cells, and Excel automatically performs the calculation. Here are steps:
Step 1
Right-click the cell you wish to change, and select "Format Cells."
Step 2
Click the "Number" tab in the Format Cells window.
Step 3
Click "Number" in the category list.
Step4
Enter the number of decimal places you prefer next to the field labeled Decimal Places. This can be done by manually entering the number or by clicking the up/down arrows to change the default value of 2.
Step 5
Click "OK" to change the percent into a decimal.
Kind regards, Anton
From the picture you posted, it appears that the numbers are formatted as text, this can be solved automatically by Excel using the upper left triangle that appears in the cell and click "Convert to number" (see the attached picture). You can select all the cells with the mistake and it will fix them all at once. If the triangle did not appear, then try to copy your numbers and Paste Values (from paste special, see picture 2). If not working, then you can convert all the numbers using a simple formula that uses the VALUE, LEFT, and LEN functions. If you can't do it, just drop the file here and we will do it for you.
- Badges
- Science topic