Percentage point difference number format

  • Thread starter Thread starter jane
  • Start date Start date
J

jane

I have doing a simple calculation for the difference between columns with
%'s. I need to be able to have my result shouw as whole numbers.

ie

col 1 col 2 result
4% 2% 2% points - want thisis show as 2 (without a % sign)

thanks in advance.....jane
 
jane said:
I have doing a simple calculation for the difference between columns with
%'s. I need to be able to have my result shouw as whole numbers.

ie

col 1 col 2 result
4% 2% 2% points - want thisis show as 2 (without a % sign)

thanks in advance.....jane
Click to expand...


=(A1-B1)*100
 
Back
Top