I have a db that holds a 5 digit number I want to output this to my page but I want to display a decimal eg... 345.89 <BR>I tried formatnumber() but I keep getting a comma any ideas? <BR>Thanks!!!
You can try cdbl()
It goes by your system's settings... look at them. For the standard US setup, you're going to get:<BR><BR>10,543.39<BR><BR>The easiest way to fix this (besides changing your system's settings) is to do a replace on the comma.
<BR>When I use formatnumber((45678),2), I get 45,678.00<BR>I want 456.78
Why are you using formatnumber to get that value? <BR><BR>Not to sound like Captain Obvious, but why not divide the number by 10 to get the answer you want?
Yea that would work, I just thought there was an obvious formatting function I could use. Thanks for your help!!