Discuss "format currency to display by thousands" in the ASP Development forum.

Rebelle · #1 April 29th, 2008, 03:59 PM

Hey All,

I have a currency field in SQL 2000 - money(8) in my table with value ex: 117000 and in ASP, I have the following:

Code:

<TD bgcolor="#E0FFFF" align=center><%=formatcurrency(rs("ItemCost"),0)%></TD>

It displays as $117,000 on the web view, but I don't want it to show this, I want it to show $117 only.

Is this possible?

Thanks!

Wolffy · #2 April 29th, 2008, 04:56 PM

Divide it by 1000 first and take the integer of the result.

Rebelle · #3 April 29th, 2008, 10:32 PM

Thanks Wolffy!
Here is what I did and it looks good, like $117.

Code:

<%
intItemCost = rs("ItemCost")
intItem = FormatCurrency((intItemCost / 1000),0)
%>

Code:

<TD bgcolor="#E0FFFF" align=center><%= intItem %></TD>

Thanks so much!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

The Following 2 Users Say Thank You to Wolffy For This Useful Post:
jmurrayhead (May 27th, 2008), Rebelle (June 17th, 2008)

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.