ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Please Help: display "%" sign after a number (https://www.excelbanter.com/excel-programming/434790-please-help-display-%25-sign-after-number.html)

Sam

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

Gary''s Student

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


Michelle

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



Sam

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