tmajor99
asked on
EXCEL - How to prevent EXCEl from removing leading zeros
When opening a csv file in EXCEL, how can I prevent EXCEL from removing leading zeros? For example;
CSV File EXCEL
Zip Code Zip Code
07110 7110
09888 9888
I want EXCEL to not strip off any leading zeros. In addition, is there any way to restore a leading zero after I file has been opened in EXCEL?
CSV File EXCEL
Zip Code Zip Code
07110 7110
09888 9888
I want EXCEL to not strip off any leading zeros. In addition, is there any way to restore a leading zero after I file has been opened in EXCEL?
You can format after with the Zip Code format under special. That should do what you want.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://youtu.be/2i5g9SMGWYk