Excel LEN anomaly for large numbers
A little Excel quirk to mention using LEN() with large numbers. A little Excel quirk to mention. For as long as we can remember you could get the number of digits in a number by simply using =LEN() even though the input is a number, not text. But have a look what happens for the […]