Preserve leading zeros when entering numbers in Excel. This video shows two examples to keep the leading zeros of your numbers.

🚀 Download my '40 Incredible Excel Tips' book for FREE - [ Ссылка ]

When entering numbers such as telephone numbers and ID's in Excel, the leading zeros are removed as they are viewed as redundant data.

However you may need them. The two examples used in this video are to store them as text using a technique whilst typing, and then to use Custom Formatting which keeps them consistent and numeric.

Find more great free tutorials at;
[ Ссылка ]

Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть