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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oh, how stupid of me. :)
Or:
Text1 = Format$(Text1, "0.00\%")
Anthony
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"
Text1 = Format$(Text1, "0.00") & "%"