View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default multiplying a negative number

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?