{"id":11943,"date":"2022-10-13T08:22:54","date_gmt":"2022-10-13T08:22:54","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=11943"},"modified":"2024-03-28T11:19:41","modified_gmt":"2024-03-28T11:19:41","slug":"keep-leading-zeroes-in-excel-csv","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/keep-leading-zeroes-in-excel-csv\/","title":{"rendered":"Keep Leading Zeroes in Excel CSV"},"content":{"rendered":"\n
By default, Excel removes leading zeroes from any real number you enter in a cell. This is because the zeroes are insignificant. Sometimes you may want to keep the leading zeroes as in the case of phone numbers, credit card numbers, product codes, and so on. This tutorial shows you how to keep leading zeroes in an Excel CSV file.<\/p>\n\n\n\n
We will use the following dataset in our examples:<\/p>\n\n\n\n