Please repeat your question and include further explanation in the body of
your message, not just in the Subject line.
Your question is unclear to me. But perhaps this will answer your question.
When you enter the product number, put an apostrophe (') in front. For
example, '1234567890123456789012345. That tells Excel to treat what follows
as text instead of as a number. Excell will not display the apostrophe.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.