two decimals

Gustaaf R. Möhlmann

unread,

May 1, 2013, 6:27:40 AM5/1/13

to

Dear list members, Concerning TB 9.01I'm not successful in formatting the following variable to be displayed with 2 decimals in a field.The variable is:guusvar = 1054.9876I want to be displayed in a field as: 1054.99How to format this ? format number guusvar as "#.##"
Tekst of field "textfield" = guusvar

does not work
Any help appreciated.
Thank you in advance.

Met vriendelijke groet,
M�hltiVastgoed

Guus M�hlmann
Gecertificeerd en NVM-be�digd Register-Makelaar-Taxateur o.z. & jurist

Key Lawson

unread,

May 1, 2013, 5:27:44 PM5/1/13

to

This works fine in V8.5, Guus --

to handle buttonClick
local REAL gussVar

gussVar = 1054.9876
get gussVar
format it as "#.##"
text of field "nbr" = it
end

The field "nbr" shows: 1054.99

Maybe I'm missing your question somehow.
Key
_______

At 03:27 AM 5/1/2013, you wrote:
>Dear list members=2C Concerning TB 9.01I'm not successful in formatting the=
> following variable to be displayed with 2 decimals in a field.The variable=
> is:guusvar =3D 1054.9876I want to be displayed in a field as: 1054.99How =

>to format this ? format number guusvar as "#.##"

>Tekst of field "textfield" =3D guusvar
>=20

> does not work
>Any help appreciated.
>Thank you in advance.
>

>Met vriendelijke groet=2C
>M=F6hltiVastgoed
>=20
>Guus M=F6hlmann
>Gecertificeerd en NVM-be=EBdigd Register-Makelaar-Taxateur o.z. & jurist
>
>
>
> =

Gustaaf R. Möhlmann

unread,

May 2, 2013, 2:58:55 AM5/2/13

to

Dear Kew,

Thank you for your reply.
Initially no succes with your script.
However, after changing "#.##" into "#,##" it works.
I do still not know why ?
However problem solved.
Thank you agaim.

Guus Möhlmann

> Date: Wed, 1 May 2013 14:26:59 -0700
> From: key.L...@VERIZON.NET
> Subject: Re: two decimals
> To: tool...@LISTSERV.PLATTECANYON.COM

J-P.A

unread,

May 2, 2013, 9:08:28 AM5/2/13

to

Why don't you use :
xxx = round(xxx,-2)

May be I missed something...

Cheers, Jean-Paul.

Le 02/05/2013 08:58, Gustaaf R. Möhlmann a écrit :
> Dear Kew=2C
> =20

> Thank you for your reply.
> Initially no succes with your script.

> However=2C after changing "#.##" into "#=2C##" it works.

> I do still not know why ?
> However problem solved.
> Thank you agaim.

> =20
> Guus M=F6hlmann
>
>
>
> =20
>
>> Date: Wed=2C 1 May 2013 14:26:59 -0700

>> From: key.L...@VERIZON.NET
>> Subject: Re: two decimals
>> To: tool...@LISTSERV.PLATTECANYON.COM

>> =20
>> This works fine in V8.5=2C Guus --
>> =20

>> to handle buttonClick
>> local REAL gussVar

>> =20
>> gussVar =3D 1054.9876

>> get gussVar
>> format it as "#.##"

>> text of field "nbr" =3D it
>> end
>> =20

>> The field "nbr" shows: 1054.99

>> =20

>> Maybe I'm missing your question somehow.
>> Key
>> _______

>> =20
>> =20
>> =20
>> At 03:27 AM 5/1/2013=2C you wrote:
>>> Dear list members=3D2C Concerning TB 9.01I'm not successful in formattin=
> g the=3D
>>> following variable to be displayed with 2 decimals in a field.The vari=
> able=3D
>>> is:guusvar =3D3D 1054.9876I want to be displayed in a field as: 1054.=
> 99How =3D

>>> to format this ? format number guusvar as "#.##"

>>> Tekst of field "textfield" =3D3D guusvar
>>> =3D20

>>> does not work
>>> Any help appreciated.
>>> Thank you in advance.
>>>

>>> Met vriendelijke groet=3D2C
>>> M=3DF6hltiVastgoed
>>> =3D20
>>> Guus M=3DF6hlmann
>>> Gecertificeerd en NVM-be=3DEBdigd Register-Makelaar-Taxateur o.z.& juri=
> st
>>>
>>>
>>> =3D
>> =20
> =
>
>

metatools

unread,

May 2, 2013, 11:26:50 AM5/2/13

to

Hi Gustaaf

The difference is in the sysDecimal property.

In US is "." bat in EU is ","

Cheers

Stefano Reissner

-----Messaggio originale-----
Da: ToolBook Discussion List [mailto:tool...@LISTSERV.PLATTECANYON.COM] Per
conto di Gustaaf R. Möhlmann
Inviato: giovedì 2 maggio 2013 8.59
A: tool...@LISTSERV.PLATTECANYON.COM
Oggetto: Re: two decimals

Dear Key,

Thank you for your reply.
Initially no succes with your script.

However, after changing "#.##" into "#,##" it works.

I do still not know why ?
However problem solved.
Thank you agaim.

Guus M=F6hlmann

Key Lawson

unread,

May 2, 2013, 4:44:07 PM5/2/13

to

Thanks for clearing that up, Stefano.
I was confused, too. :-)
Key
_______

At 08:26 AM 5/2/2013, you wrote:
>Hi Gustaaf
>
>The difference is in the sysDecimal property.
>

>In US is "." but in EU is ","

>
>Cheers
>
>Stefano Reissner
>
>-----Messaggio originale-----

>Da: ToolBook Discussion List [mailto:tool...@LISTSERV.PLATTECANYON.COM] =
>Per
>conto di Gustaaf R. M=F6hlmann
>Inviato: gioved=EC 2 maggio 2013 8.59

>A: tool...@LISTSERV.PLATTECANYON.COM
>Oggetto: Re: two decimals
>
>Dear Key,
>
>Thank you for your reply.
>Initially no succes with your script.
>However, after changing "#.##" into "#,##" it works.
>I do still not know why ?
>However problem solved.
>Thank you agaim.
>

>Guus M=3DF6hlmann