Excel Keep Leading Zeros – Text vs. Numbers – Advanced Options

nnnn

Microsoft Excel Tips and Tricks

nExcel is coming out with a new feature that allows you to keep leading zeros. When entering data in Excel, it is important to know when to use Text vs. Number fields. Users will frequently use numbers when they should use text. Examples of fields that should be text include Social Security Number, Employee number, Product Number, Zip codes, and account numbers. The reason they are text is they may have leading zeros, and you are not going to need to perform a calculation on them.nnnn

Credit Chris Menard

n

Leave a Reply

Your email address will not be published. Required fields are marked *