When I use in cel b1 =value(a1) where a1='12345678901234567890123, the value is then displayed in an exponential form. Which is not what I want. I need to see it with all 23 digit values.
So, if I say add 1 to cel b1, the result in c1 is still an exponential value. No good
Imagine if I was to want to have 5 cells (A1 to A5) with a 23 digit value each derived from the formula A1=23 digit value, A2=A1+1, A3=A2+1, A4=A3+1, A5=A4+1. I would need to see all results without exponentialo values.
This message was edited by PocketNeo on 2002-12-30 09:58