Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag for United States of America

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?
SOLUTION
Avatar of Shanan212
Shanan212
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did any of the above help you?
Avatar of Richard Korts

ASKER

I have not had time to try these yet; other pressing issues, but I will.

Thanks
Sorry to be a pest but...
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013