![]() |
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 |
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 |
Please Help: display "%" sign after a number
Or
Percent.Value = Format(Percent.Value, "0.0") & "%" M "sam" wrote in message ... 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 |
Please Help: display "%" sign after a number
Thanks michelle, That was What I needed
"Michelle" wrote: You could try Percent.Value = Format(Percent.Value/100, "0.0%") M "sam" wrote in message ... 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 |
All times are GMT +1. The time now is 03:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com