<div>
<div class="content wysiwyg-content">
I am reading data from an excel file to an ASP via VBScript. In excel I have it set to round to the 1st place after the decimal but when I pull it to the web it shows the whole number, sometime 6 - 8 places after thedecimal. How can I round that number? The way I am getting the data is just as follows.<br />
<br />
&lt;td&gt;&lt;%=rs.fields(5)%&gt;&amp;nbsp<wbr />;&lt;/td&gt;
</div>
</div>


I am reading data from an excel file to an ASP via VBScript. In excel I have it set to round to the 1st place after the decimal but when I pull it to the web it shows the whole number, sometime 6 - 8 places after thedecimal. How can I round that number? The way I am getting the data is just as follows.

<td><%=rs.fields(5)%>&nbsp;</td>

ROund number to 1st decimal place in VBScript.

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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.

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.