Main Profile

At A Glance

Store Numbers as Text in Excel - Keep Leading Zeros

Go to http://www.teachexcel.com for more. This Excel tutorial shows you how to store a number in Excel as text. This allows you to include leading zeros with your numbers, such as 0001. Also, this feature can help you better search through your data, using lookup functions and formulas, when numbers in the lookup range are stored as text rather than numbers. This is a great little trick in Excel that can save you a lot of time when working with your data set.
Length: 02:48

Contact

Questions about Store Numbers as Text in Excel - Keep Leading Zeros

Want more info about Store Numbers as Text in Excel - Keep Leading Zeros? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question