>>>>>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.
>
>I think I am more impressed that you understand than what he wrote :)

I understood it when I read it. Don't ask me to repeat it tomorrow.
I was fortunate to have as one of my programming mentors a brilliant mathematician who forced this English major to learn to appreciate the beauty of mathematics.
So, while I'll never be able to do what Lutz does, I can follow it, appreciate its elegance and apply it.