View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Please Help: display "%" sign after a number

Percent.Value = Percent.Value & "%"
--
Gary''s Student - gsnu200907


"sam" wrote:

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