User Profile

RonHouston · Oct 12 '06, 11:44 PM

Hi,

thanks everyone. I finally got everything to work properly.

it's really appreciated.

Thanks again.
Ron.

RonHouston · Oct 12 '06, 03:18 PM

Hi,

thanks for the help.
I'm still a bit stuck though. Sorry to bother you this much.

the variable that doesn't format properly is actually variableThree
where
variableThree = variableOne + variableTwo

I tried putting these two lines but it won't work:
variableTwo = format(variable Two, "0.0000")
variableThree = format(variable Three, "0.0000")
...

RonHouston · Oct 12 '06, 08:26 AM

Hi,

it's a single, and it needs to be one

Thanks.
Ron.

RonHouston · Oct 12 '06, 08:20 AM

Hi again.

Using the above formatting technique won't stop variableOne to display in scientific format. any way to always have zeros instead of E?

thanks

Ron.

RonHouston · Oct 12 '06, 07:09 AM

this actually worked:
variableOne = Format(variable One, "0.0000")
thanks a lot everyone.

Ron.

RonHouston · Oct 12 '06, 06:54 AM

variableOne = Format(variable One, "#.####")

thought this would work but it doesn't really work
it doesn't add a zero to numbers that have less than 4 digits after the decimal.

Ron.

RonHouston · Oct 12 '06, 06:46 AM

Hi, and thank you willakawill,
that's almost what I want, althouth Round actually rounds the variable variableOne.
All I want it to do is to troncate... and I was hoping there would be a way to Format a variable to only hold the first 4 digits, without rounding it.

Actually what if I wanted only the four numbers after the decimal places.

if variableOne = 0.1234567890
then I would want it to be 0.1234...

RonHouston · Oct 12 '06, 05:38 AM

it didn't work.
here's what I have:

Code:

variableOne = algorithm_here
//for this example sake let's say
//variableOne = 0.99999999999999 that's 14 times the number 9
textBox = variableOne

Instead of textBox showing the whole number I'd like it to show only the first 4

thank you

Ron.

RonHouston · Oct 12 '06, 05:32 AM

Hi,
thanks a lot sire.
May I ask what the 23 is for?

again, Thank you

Ron.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Limit any number to four digits?