A3 shows 1000.000
=LEN(A3) resolves to 4

I see 8 characters.

Another oddity:

A5 has the formula =1.023254546*10^3 which is displayed as 1023.25
=LEN(A5) resolves to 11

Neither of these make sense.

A7 shows 0
=LEN(A7) resolves to 1. This makes sense.

A9 shows 0.01
=LEN(A9) = 4. This makes sense.

Thoughts?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.