Avoid exponential format

[cdt]

Hello how can I avoid the exponential format,
I want to get a value with 6 decimal digits.
I attach an image of the confguration and the result, which is sometimes correct and another gives me an exponential format.

setting

Outcome

[l'andorrà]

@cdt Try this formula instead:

=NormalizeDouble($,0)

Where 0 is the nuber of decimal digits.

[cdt]

it does not work, I have tried the two formulas:
NormalicezeDouble (variable, 2)
DoubleToString (variable, 2)
I have also tried with = sign in front
= NormalicezeDouble (variable, 2)
= DoubleToString (variable, 2)
and it works randomly, sometimes yes, sometimes not, sometimes it respects the n of decimals, others not, and others it puts it in scientific format

[l'andorrà]

@cdt When I said this: =NormalizeDouble($,0) I dodn't mean the '$' should be substituted by a variable. Just use that '$' symbol as is. You can insert this formula in the 'Adjust' tab below the variable.

[cdt]

ok, gracias, voy a probar.

[l'andorrà]

@cdt No hay de qué.