View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jane Jane is offline
external usenet poster
 
Posts: 202
Default Percentage point difference number format

thank you!!!

"Niek Otten" wrote:

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