Fomat decimal numbers in ASP

[sarahbarnard]

I use Dreamweaver to generate asp pages. I have an access database with numbers. In access the numbers are displaying and formatted to Double, fomat 2 decimals. On teh website the numbers don't display 0's after the decimal point, ie 2.00 shows as 2 , or 2.10 displays as 2.1 etc How could I force the diaplay of 2 decimals, showing the non-significant 0's as well.

I have searched the forum, but cannot find the answer on existing threads

Please help! Thank you
Sarah

[gateshosting]

All you have to do is use the formatnumber() function...

formatnumber(192.394884,2) would give you 192.3... it will also round up.

Best regards,

Michael C. Gates

[sarahbarnard]

All you have to do is use the formatnumber() function...

formatnumber(192.394884,2) would give you 192.3... it will also round up.

Best regards,

Michael C. Gates

Hi Michael, thank you very much for your reply
Does it mean formatnumber(dynamic database variable field'sname, 2) ??
I have tried maybe making a mistake
Have never used formatnumber before
where should I type format number , I assume in the use statement?