View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gator gator is offline
external usenet poster
 
Posts: 66
Default Formula problem with decimal

I am multiplying two cells to get a result in a third cell. the result comes
out to be 18.525. I format the decimal to show only two numbers, like 18.53
but when I multiply this number to another number it is multiplying like
18.525. How can I make it multiply like 18.53?
thanks