Hello all,
Whenever you export a numeric colum with leading zeros, excel trims/removes the leading zeros. I was running into an issue where I needed the leading zeros to be as is since they were meaningful(like in the case of zip codes which start with a zero) After a lot of searching I found the article
How to add leading zeros in Excel on eHow.com
which explains process in very simple terms. Here is the link to the article
http://www.ehow.com/how_4703826_add-leading-zeros-excel.html
Happy Excelling
No comments:
Post a Comment