Excel LEN Function Returning Wrong Count – More than the characters count in cell
Facing a very strange situation while using Excels LEFT, RIGHT, LEN functions on a cell. Cell contains a numeric value (00361941) to be exact. When I try to use LEFT(Cell,6), it gives 00361 (should be 003619), when I use RIGHT(Cell,6), it gives 61941 (should be 361941).