Convert string to float | dynamic decimals

[schmidtj]

Hi,

i have numeraicl float data which i deen to convert to a lik float.

I used the #num() function and it works fine.

The problem is, that the number of decimals in my incomming data can vary (max. 2 decimals).

I can have numers linke this:

49

7101.1

2.88

0.1

0.34

When is use Num#(field, '#.##')  i cover all the data with 2 decimals but not the others.

What can i do to dynamically convert the data with one and two decimals?

Thanks a lot.

[sunny_talwar]

Is this data not read as number already? If not, then may be try only this Num#(field)

[schmidtj]

No unfortunately not.

Num#(field) is not working i'm afraid.

This will only convert the numbers without decimals in my case.

[chriscammers]

Are you looking for output where all the values have the same format?

Try Num(Field,'#.00') which will tweak the output format.