View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Please Help: display "%" sign after a number

Hi All,

How can I display a % sign after a number in a text box.

SO for eg, If I type in 12 i want it to display 12.0%
rite now If I type in 12, it gives me 1200.0%
Here is my code: Percent.Value = Format(Percent.Value, "##.0%")

Please Help