how to format small decimals without the E scientific notati

numbers smaller than 0.1 format very ugly

is there a way to format something so it just shows up how you'd expect it to?

like:

formatdecimal(2,0.01235)

I just want it to say

0.01

but instead it formats to

e+000

http://dl.dropbox.com/u/1013446/seriously.cap

If there's a way to put a number into a string, then you can just print that instead, right? And if you also want to format it, then you can multiply by 100, use the floor() function, and then divide by 100 and put that in the string.

(If you managed to catch my previous post before I deleted it, yeah, that doesn't work at all. My bad!)

Here's one way:

int(0.01)&"."&ZeroPad(int(100*0.01),2)

oh thanks guys, just came back here, my solution was much uglier:

assuming your decimal number was x:

((x<0.1)?("0."&right(formatdecimal(1+x,3),2)):formatdecimal(x,3))