How To Stop Automatic Standard Form

[RazerM]

How do i stop a number becoming 3e-005 instead of 0.00003? like this

MsgBox(0, "test", 0.00003)

I'm sure there is an answer to this but I don't know.

Edited April 21, 2006 by RazerM

[RazerM]

Is this not possible?

[neogia]

Take a look at StringFormat()

MsgBox(0,"",StringFormat("%.5f", .00003))

Edit: Forgot %

Edited April 21, 2006 by neogia

[Bokkie]

Is this not possible?

I can't think of any simpler way but this works:

MsgBox(0, "test", StringFormat("%0.5f",0.00003))

Edit: neogia beat me to it. Think of mine as confirmation!

Edited April 21, 2006 by Peter Hamilton-Scott

[Valuater]

maybe...

$Float = "0.00003"

$len = StringLen($Float) -2

$Answer = StringFormat ( "%."&$len&"f", $Float )

MsgBox(0, "test", $Answer)

this is 2nd confirmation, with added unknown string length

8)

Edited April 21, 2006 by Valuater

[RazerM]

it is being used in a certain calculation. I now have an If statement and if it is less than or equal to the value causing this it uses string format. Thanks guys