-4*.1=0? why not -.4?

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

"M.A.Tyler" wrote:

-4*.1=0? why not -.4?

That's embarrasing, thank you!

"Tom Hutchins" wrote:

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

"M.A.Tyler" wrote:

-4*.1=0? why not -.4?

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
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1