format numbers

[eddie wang]

I have the following html with result set. I like to have gas_revenue
display like $99,9999 and I like to have gas_price dsplay like 9.99.
Can I use html to accomplish this? Thanks.

<td align="right"><Font
class=content4><%=ars.Fields("GAS_REVENUE")%></td>

<td align="right"><Font class=content4><%=ars.Fields("GAS_PRICE")%></td>

 

[Aaron Bertrand - MVP]

Yes, look at the formatcurrency and formatnumber functions.

 

[Bullschmidt]

Visual Basic Scripting Edition Functions

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script5
6/html/vtorifunctions.asp

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...