This content has been marked as final.
Show 4 replies

1. Re: Avoid "scientific"/exponential notation in numbercalculation
jbante Jan 25, 2013 4:46 AM (in response to kosmo)1 of 1 people found this helpfulTry using the Mod() and Div() functions instead of Middle().

2. Re: Avoid "scientific"/exponential notation in numbercalculation
kosmo Jan 25, 2013 5:19 AM (in response to kosmo)Hello,
sounds wonderful. Thank You so much. Something like
Right (Div ($TheCode;10^$PositionFromRight); 1)
should work, e.g.. I have to think for other examples.
Christian Bredlow

3. Re: Avoid "scientific"/exponential notation in numbercalculation
comment Jan 25, 2013 5:33 AM (in response to kosmo)Christian Bredlow wrote:
Something like
Right (Div ($TheCode;10^$PositionFromRight); 1)
should work,
It's best to use only numeric functions when dealing with a number. To extract the digit at the nth position (from right), try =
Mod ( Div ( number ; 10 ^ ( n  1 ) ) ; 10 )

4. Re: Avoid "scientific"/exponential notation in numbercalculation
kosmo Jan 25, 2013 6:13 AM (in response to comment)Thank You so much, too. Works! Twodaybraintorture has an end...
Unfortunately I can only give one "right answer".
Christian Bredlow