Richard Korts
asked on
Excel Issue
We have a column in a spreadsheet that contains part numbers; in some cases they are, in fact, numbers. In many cases, they are alphanumeric.
Some of them have leading zeros; when the leading zero is added, Excel eliminates it because it thinks it is numeric & therefore not needed.
How can I prevent Excel from doing that?
Some of them have leading zeros; when the leading zero is added, Excel eliminates it because it thinks it is numeric & therefore not needed.
How can I prevent Excel from doing that?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did any of the above help you?
ASKER
I have not had time to try these yet; other pressing issues, but I will.
Thanks
Thanks
Sorry to be a pest but...
You're welcome and I'm glad I was able to help.
Marty - MVP 2009 to 2013
Marty - MVP 2009 to 2013