Working with format function "0.00%"

irina_1973
irina_1973 used Ask the Experts™
on
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 ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
why not use

Format$(Text1,"#0.00")

?

Commented:
Put the "%" outside the format:

Text1 = Format$(Text1, "0.00") & "%"

Commented:
oh, how stupid of me. :)
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Top Expert 2012

Commented:
Or:
Text1 = Format$(Text1, "0.00\%")

Anthony

Commented:
Did I get points for this? You meant rspahitz didn't you?

Commented:
:)  No biggie...

Commented:
You are very kind rspahitz. How about giving me say 10^5 points from your total score? :)

Commented:
Sorry--> "Available Question Points 6250"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial