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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting an ASP page

Status
Not open for further replies.

teters

Technical User
Oct 4, 2002
16
0
0
US
I have successfully created my ASP page (BIG thanks to all of you in this forum). Now I would like to format the data in the ASP page. My Excel spreadsheet is displaying numbers with 2 decimals places. If the numbers on the spreadshet show decimcals (123.45) it will show in the ASP page. If the number shows 123.00, the number will only show as 123 in the ASP page. Is there anyway to force the numbers on the ASP page to always show 2 decimal places.

Any information would be greatly appreciated.

Thanks.

teters
 
use the FormatNumber Function
syntax
FormatNumber(Expression [,NumDigitsAfterDecimal]) A language that doesn't affect the way you think about programming is not worth knowing.
admin@onpntwebdesigns.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top