>>>>>>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.
I won't remember any of the formulas you and Lutz have exchanged. But I will remember who to go to if I need help, you :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham