Percentage point difference number format
Multiply by 100 and format as General
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"jane" wrote in message
...
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
|