View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freddo
 
Posts: n/a
Default I am doing a calculation in excel, I am multiplying a figure by a

I have multiplied a figure by 30% eg 71.35 to give 92.76 then compared it
against another column with 92.76 in it and timed it by 1 and the answer
should be 0.00 but because of the extra decimal places it comes up as .01. I
s there any way you can use the figure as shown after it has been formatted
to 2 decimal places rather than the hidden decimal places