Learn Excel Episode 392: Leading Zeroes

Posted in Companies, Podcasts on July 05, 2008


Learn Excel Episode 392: Leading Zeroes

Have you ever tried to enter an ID number that starts with zeroes? Excel automatically removes the leading zeroes, making it impossible for your VLOOKUPs to work. Rather than resorting to using a Zip Code format, try one of the tricks in Episode 392 to make Excel keep the leading zeroes.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel