Thread: format currency to display by thousands

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!

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

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!!!