Easy Format Number question?

[mmj]

I have a number in a database with numbers for acreages (eg. 13319, 1757002, 2063). The decimal place would normally be 3 spaces from the end and not rounded. I want a decimal placed in the 3rd space from the last character, then rounded to 2 decimal spaces (eg. 13.32, 175.70, 2.06) I hope I am making this clear. The number is a long integer type in my Access Database. My webpage uses ASP, VbScript and SQL.

I tried:
html= html & addRow2("Acres", FormatNumber(rs("ACRES"),2))

and ended up with 2 0's (eg. 13319.00, 2063.00) tacked on to the end. I'm not sure what I'm doing wrong here. Any help would be appreciated.

Thanks,
MJ

[mcnd]

Originally Posted by mmj

html= html & addRow2("Acres", FormatNumber(rs("ACRES"),2))

Well, what if you use

html= html & addRow2("Acres", FormatNumber(rs("ACRES")/1000,2))

[mmj]

Thanks! That did work. I changed the 1000 to 10000 but it did the trick!