Link to home
Start Free TrialLog in
Avatar of irina_1973
irina_1973

asked on

Working with format function "0.00%"

I have a TextBox that contain a DataFormat - %
So, I write
Text1 = Format$(Text1, "0.00%")
But when I put to this field a value 12 ,for example ,
it's concert to 1200.00%

But I want that it will convert to 12.00% .How can I do it ?
ASKER CERTIFIED SOLUTION
Avatar of Kimpan
Kimpan
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Put the "%" outside the format:

Text1 = Format$(Text1, "0.00") & "%"
oh, how stupid of me. :)
Avatar of Anthony Perkins
Or:
Text1 = Format$(Text1, "0.00\%")

Anthony
Did I get points for this? You meant rspahitz didn't you?
:)  No biggie...
You are very kind rspahitz. How about giving me say 10^5 points from your total score? :)
Sorry--> "Available Question Points 6250"