| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to divide a number with "less than" sign? ie: <1/1000 = <0.001 | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to "sign" macro with "digital certificate"? | New Users to Excel | |||
| How to display "+" sign | Excel Discussion (Misc queries) | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
Linear Mode
