First off, why do you say only the first number returns the correct length?
It looks to me that the first 3 return the correct length. As for the last
3, that does look odd. Just out of curiosity, how are those cells formatted
(and if they are Custom Formatted, show it to us)?

--
Rick (MVP - Excel)


"MikeF" wrote in message
...

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)