M
MikeF
In the following table, the LEN formula returns the incorrect number of
characters.
The first number 34,... is in cell b12, it's corresponding LEN formula to
the right in cell b13.
It is the only one that returns correctly, the rest of the table is
obviously inaccurate.
*** The numbers themselves are based on a "to the nth power" formula.
Does anyone know why this is happening?!?
Thanx......
34,596,000,000 11 =LEN(B12)
124,545,600,000,000 15 =LEN(B13)
448,364,160,000,000,000 18 =LEN(B14)
258,257,756,160,000,000,000 16 =LEN(B15)
12,654,630,051,840,000,000,000 18 =LEN(B16)
34,218,119,660,175,400,000,000,000 20 =LEN(B17)
characters.
The first number 34,... is in cell b12, it's corresponding LEN formula to
the right in cell b13.
It is the only one that returns correctly, the rest of the table is
obviously inaccurate.
*** The numbers themselves are based on a "to the nth power" formula.
Does anyone know why this is happening?!?
Thanx......
34,596,000,000 11 =LEN(B12)
124,545,600,000,000 15 =LEN(B13)
448,364,160,000,000,000 18 =LEN(B14)
258,257,756,160,000,000,000 16 =LEN(B15)
12,654,630,051,840,000,000,000 18 =LEN(B16)
34,218,119,660,175,400,000,000,000 20 =LEN(B17)