>>>Edit: Protip
>>>The count of 2 you have to use is in the number of decimal places.
>>>n places means divide by 2^n
>>
>>Clever, clever, Lutz.
>>How did you figure that one out?
>
>Bill,
>
>simple. To much binary - hex - deci conversation
>
>10 is only divisible (whole numbers, as daughter says behind me) by 2 and 5
>
>0.1 is a tenth. A half times a fifth. IOW it's (2^-1)*(5^-1)
>You can put one half (2^-1) into it > 0.5
>0.01 is a tenth times a tenth, IOW (2^-1)*(5^-1)*(2^-1)*(5^-1)=(2^-2)*(5^-2)
>You can put one quarter (2^-2) into it > 0.25; (0.5); 0.75
>....
>
>There shoud be a way using LOG10() without counting numbers, but I'm to lazy right now. (For the whole part it's INT(log10(ABS(EVL(INT(tnNumber),1))))+1 )

Understood!
Thank you.