"Bob Phillips" wrote...
This doesn't work for me at all, it returns 15 for 34.45.
Looking at it MOD(ABS(A1),1) evaluated to .450000000000003, which I
would take is caused by lack of precision when using MOD.
....
The motivation may have been sound. The implementation wasn't. It should be
as simple as
=LEN(x)-LEN(INT(x))-1
though that'd work with values stored and used but not displayed.
What should the result be for, say, =32+1/3?
|