M
M.A.Tyler
-4*.1=0? why not -.4?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Hutchins
If you enter -4*.1 in a cell, it does return -0.4
You probably have the cell formatted to show zero decimal places. Use the
Increase Decimal button on the cell and I think you will see the result you
expected.
Hope this helps,
Hutch
You probably have the cell formatted to show zero decimal places. Use the
Increase Decimal button on the cell and I think you will see the result you
expected.
Hope this helps,
Hutch
M
M.A.Tyler
That's embarrasing, thank you!
Tom Hutchins said:If you enter -4*.1 in a cell, it does return -0.4
You probably have the cell formatted to show zero decimal places. Use the
Increase Decimal button on the cell and I think you will see the result you
expected.
Hope this helps,
Hutch
C
Chris_Bode via OfficeKB.com
Multiplying -4*1 returns -0.4, you must have formatted the cell to zero
decimal place.
To resolve this, you can follow following steps
1. Select the cell in which the result is displayed
2. Right click on the cell and click Format Cells on the pop up box
3. Select Number on the Category List box
4. In the Negative Numbers list box select -1234.10
5. Set Decimal Places to 2
6. Click OK
You will get the desired result…….
Chris
decimal place.
To resolve this, you can follow following steps
1. Select the cell in which the result is displayed
2. Right click on the cell and click Format Cells on the pop up box
3. Select Number on the Category List box
4. In the Negative Numbers list box select -1234.10
5. Set Decimal Places to 2
6. Click OK
You will get the desired result…….
Chris