Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Enter Values Starting with Zero in Excel 2013

In this video you’‘ll learn how to input values which start with zero in Excel. If the data in any given cell starts with zero, Excel will automatically delete it and can often completely change important information such as Zip codes or dates.

Select the cell that contains the value starting with zero.
Type an apostrophe (’) in front of the number.
Now Excel will preserve the value with the zero when you move the cursor away from the cell.
Another method to preserve the zero at the beginning is to change the format settings from number to text.
Select Format Cells,
Click on Number,
select Text as the format.