Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make the number have only one decimal place

Status
Not open for further replies.

d1004

Programmer
May 9, 2002
78
US
I have the following calculation like

qrt25 = countofq25/q35gmnthtotal and the result I got is .59678576

What I want is for it to output 59.6% Is there a datatype or method that I can use? Thank you!!!

 
But
qrt25 = FormatPercent(qrt25,1)

will return one decimal

 
you had to do that. I just refreshed my memory with the syntax in my reference and was about to say that.

syntax
FormatPercent(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

[lol]
admin@onpntwebdesigns.com
 
Onpnt, if you can remember that whole definition without looking it up, I think we need to just pay you to answer everyones questions ;) Me, I have to look up response.wri...whats that command again?
:p
-Tarwn ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top