Solution – Preserve Leading Zeros in Excel

If you happen to copy data from somewhere to excel (such as a data in SQL format), you would have noticed that excel does not store leading zero. There are some solutions that lets you have exact number of leading zeros but what if you have leading zero with some numbers and no zeros with the other. The exact number of zeros solution will force you to use zeros with numbers that did not have these zeros before. Here is the solution.

Preserve Leading Zeros in Excel

You are copying data from an SQL table, some of the numbers has leading zeros, other do not. Copy the text in clipboard, open the Excel file, format the field which is supposed to contain this number first, then copy the data. The leading zeros will be maintained!

Leave a Reply

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