May 25 2022 02:48 AM
Hi all,
When I divide a value (e.g 5.139) /2 it gives me the correct answer but in the format of 2570 instead of 2.5. Any fixes?
May 25 2022 03:03 AM
Do you perhaps use comma as decimal separator? If so, Excel interprets the . in 5.139 as the thousands separator.
May 25 2022 03:56 AM
Thanks for your reply Hans. The file did use the comma as the separator originally but i rectified this by changing the ',' to '.' in the options, advanced section. I thought that perhaps this would solve my issue but it hasn't so far.
May 25 2022 04:09 AM
What happens if you recalculate the formula, for example by pressing F2 in its cell, then pressing Enter?
May 25 2022 05:26 AM
May 25 2022 06:26 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
May 25 2022 06:46 AM
May 25 2022 08:27 AM
I suspect it's still a matter of confusion about the decimal separator.
On my computer, period/dot/point is the decimal separator, and comma is the thousands separator.
When I open your workbook, I see this:
As you can see, columns B and C contain a comma = thousands separator. So for example, the value in B2 is five thousand one hundred and thirty-nine.
But columns D to G contain points, so the value of D2 is ten-and-a-half, and not ten thousand five hundred.
May 26 2022 01:08 AM
May 26 2022 01:17 AM
SolutionYou can do the following:
Enter 1000 in an empty cell.
Copy this cell (Ctrl+C).
If you want to multiply some cells with 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Multiply, then click OK.
Or if you want to divide some cells by 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Divide, then click OK.
You can then clear the cell in which you entered 1000.
May 26 2022 01:59 AM
May 26 2022 01:17 AM
SolutionYou can do the following:
Enter 1000 in an empty cell.
Copy this cell (Ctrl+C).
If you want to multiply some cells with 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Multiply, then click OK.
Or if you want to divide some cells by 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Divide, then click OK.
You can then clear the cell in which you entered 1000.