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!

Advertisements
This entry was posted in Tutorials/Tips. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s