Control decimals

[clara]

Hi all,

In my case, if the number is large enough, I would like to decrease the
decimal places,
for example, 999.121 should be changed into 999.1, and if the number is
small for example 23.123, I would like to keep the decimal places
I display the numbers in textbox controls

Clara

thank you so much for your help

 

[Tom Lake]

Hi all,

In my case, if the number is large enough, I would like to decrease the
decimal places,
for example, 999.121 should be changed into 999.1, and if the number is
small for example 23.123, I would like to keep the decimal places
I display the numbers in textbox controls

Left(Trim(Str([YourNumber])), 5)

will give you up to five characters but will truncate rather than round.

999.192 will be 999.1 after the transformation.

Tom Lake

 

[clara]

Hi there,

if a number is >= 100, I would like to keep decimal places equal to 1 , for
example instead of displaying 105.156, 105.2 is preferred, and when a number
is < 100, I would like to keep decimal places to 3, for example 99.675

Clara