Equation Miscaculation

from the immediate window:
? val("10,000")
10
? cdbl("10,000")
10000

so you might want to use cdbl instead of Val.

--
Regards,
Tom Ogilvy

"helmekki" <[email protected]> wrote in
message news:[email protected]...
>
> Hi there
> When I put this formating to the value of TextBoxs,
>
>
> Code:
> --------------------
> Gtot.Value = Format(Gtot.Value, "#,##0.000")
> tot.Value = Format(tot.Value, "#,##0.000")
> bal.Value = Format(bal.Value, "#,##0.000")
> --------------------
>
>
> Then the result of this line is always 1 or not correct
>
> Code:
> --------------------
> bal.Value = val(Gtot.Value) - val(tot.Value)
> --------------------
>
>
> How can get the correct result out of equation ?
>
>
> --
> helmekki
>
>
> ------------------------------------------------------------------------
> helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
> View this thread: http://www.excelforum.com/showthread...hreadid=486844
>

You don't say where these objects are, but I tried textboxes on a userform
and it worked okay. What are the objects?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"helmekki" <[email protected]> wrote in
message news:[email protected]...
>
> Hi there
> When I put this formating to the value of TextBoxs,
>
>
> Code:
> --------------------
> Gtot.Value = Format(Gtot.Value, "#,##0.000")
> tot.Value = Format(tot.Value, "#,##0.000")
> bal.Value = Format(bal.Value, "#,##0.000")
> --------------------
>
>
> Then the result of this line is always 1 or not correct
>
> Code:
> --------------------
> bal.Value = val(Gtot.Value) - val(tot.Value)
> --------------------
>
>
> How can get the correct result out of equation ?
>
>
> --
> helmekki
>
>
> ------------------------------------------------------------------------
> helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
> View this thread: http://www.excelforum.com/showthread...hreadid=486844
>