View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Atshuller Stan Atshuller is offline
external usenet poster
 
Posts: 1
Default Format % Question

I have a number in percent format 5% I need it to be displayed as 5 with out
changing the formula. Excel multiplies by 100 and then add the % sign, I
need it to multiply by 100 and not add the % sign.
Is this possible?
Thanks!
Stan