If the search was working I probably wouldn't have to ask this, but:

Hi,
Can a number be formatted in ASP?
I'm retreiving data from a data base and writing it to an HTML table. Some of the data is price information. I'm trying to get it to show up in the table as a price.
I've tried using the Format function in ASP but it's giving me an error. e.g.,

Code:

---

<%ItemPryc = Format(Cdbl(rs.fields(4).value),"$##0.00")%>

---

Thanks,
Al.

First try, then ask.

Well.. that was helpful..

The Format function is not available in VBScript. You must use the FormatCurrency, FormatDateTime, FormatNumber, FormatPercent functions.

I can't for the life of me figure out why MS left out this useful function, (Maybe because it is so slow) but they did.

Thanks. That's alot easier and sanitary then my work-around below.

Code:

---

<%
If Cint(ItemPryc)-Cdbl(ItemPryc)=0 then
        ItemPryc=ItemPryc & ".00"
End If
If Len(ItemPryc)-Instr(ItemPryc,".")=1 then
        ItemPryc=ItemPryc & "0"
End If
%>

---

Al.