ASP and displaying number as price

[djh]

Hey all.

I'm displaying a number field in my Access database in currency format using the following:

FormatCurrency(blahblah)

But it displays with two decimal points that I don't want. How do I modify this?? Any easy way? Has to be an attribute, right?

[Hierophant]

FormatCurrency(Expression, NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers, GroupDigit)

The FormatCurrency function return a formatted currency value for the numeric expression.

There is one mandatory argument.

Expression

The Expression argument is the number to be converted to a currency format.


So:
<% =FormatCurrency(12345, 2) %>

Would be
$12345.00

For a complete VBScript reference visit Devguru.com. You can view it online or download it to your local PC.