<div>
&lt;%<br />
x = 8.55555<br />
y = Round(x,2)<br />
response.write y &amp;&nbsp;&quot;%&quot;<br />
%&gt;
</div>


<div>
You can use formatpercent(), but remember that doing so will multiply your number by 100.<br />
<br />
So FormatPercent(8.36) will give you 836%<br />
<br />
So do it this way:<br />
<br />
response.write(FormatPerce<wbr />nt(objRS(&quot;<wbr />YourField&quot;<wbr />)*100))<br />
<br />
<br />
FtB<br />

</div>


<div>
a better one would be<br />
<br />
&lt;%<br />
x = 8.555<br />
if Len(x) &lt;&nbsp;4 then<br />
x = x&amp;&quot;0&quot;<br />
response.write x<br />
else<br />
y = Round(x,2)<br />
response.write y &amp;&nbsp;&quot;%&quot;<br />
end if<br />
%&gt;
</div>


<div>
my original post didnt take into account those numbers that didnt have at least 2 decimal places
</div>


<div>
fritz the blank,<br />
my complete line of code is<br />
Response.Write(&quot;&lt;td&gt;&lt;font face='Arial' size='2'&gt;&quot; &amp;&nbsp;rst(&quot;percent_sent&quot;) &amp;&quot;&lt;/font&gt;&lt;/td&gt;&quot;)<br />
<br />
If I try to use <br />
Response.Write(&quot;&lt;td&gt;&lt;font face='Arial' size='2'&gt;&quot; &amp;&nbsp;FormatPercent( rst(&quot;percent_sent&quot;))&amp;&quot;&lt;/fo<wbr />nt&gt;&lt;/td&gt;&quot;)<wbr /><br />
<br />
I receive a type mismatch.<br />
<br />
As far as the result, I guess I could either divide it by 100 as you suggest (you say multiply but I'm pretty sure you meant divide..)<br />
or I can change my back end process so I don't multiply there.
</div>


<div>
Please give this a shot:<br />
<br />
Response.Write(&quot;&lt;td&gt;&lt;font face='Arial' size='2'&gt;&quot; &amp;&nbsp;FormatPercent(rst(&quot;percent<wbr />_sent&quot;)*.0<wbr />1) &amp;&quot;&lt;/font&gt;&lt;/td&gt;&quot;)
</div>


<div>
You are right, I did mean divide, but *.01 should do it.<br />
<br />
FtB
</div>


<div>
fritz_the_blank,<br />
<br />
Still receive the type mismatch error, but I believe it has something to do with the underlying rst field rather than being a problem with the FormatPercent function,<br />
because I get a type mismatch if I do ANY kind of mathmatical operation, for example <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dim myVal<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myVal = rst(&quot;percent_sent&quot;)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myVal = myVal/100-----------------<wbr />----------<wbr />----------<wbr />---&gt;I get a type mismatch here also<br />
<br />
Here's the SQL for the field, if that helps....<br />
CAST(CAST(call_ct AS decimal) <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; / CAST(pnrcount &nbsp;AS decimal) * 100 AS decimal(9, 2))<br />
<br />
&nbsp; 
</div>


<div>
Do you get an error if you do this?<br />
<br />
Response.write(CDbl(rst(&quot;p<wbr />ercent_sen<wbr />t&quot;)))<br />
<br />
FtB
</div>


<div>
Thanks ftb, that works!<br />
Vince
</div>


<div>
Glad to have helped,<br />
<br />
FtB
</div>


<div>
<div class="content wysiwyg-content">
Using vbscript, is the FormatPecent function available? When I tried to format a rst field I received an error. <br />
<br />
I return a rst field from SQL that is already multiplied by 100 in the back end, so without applying any client side formatting, the numbers display like this:<br />
8.36<br />
4.7<br />
4.26<br />
<br />
I want to display:<br />
8.36%<br />
4.70%<br />
4.26%<br />
<br />
What is the most efficient way to accomplish this using vbscript ASP?<br />
<br />
Thanks!
</div>
</div>


Using vbscript, is the FormatPecent function available? When I tried to format a rst field I received an error. 

I return a rst field from SQL that is already multiplied by 100 in the back end, so without applying any client side formatting, the numbers display like this:
8.36
4.7
4.26

I want to display:
8.36%
4.70%
4.26%

What is the most efficient way to accomplish this using vbscript ASP?

Thanks!

ASP solution to format number as percentage?

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.