Is it possible to record a number with a leading zero in Excel?

J

Jonathan HB

I have a number of product codes that have been created with a leading zero
eg 0101 . When they are imported to Excel, Excel removes the leading zero. Is
there a way that I can set Excel up so that it does NOT remove these (kind of
important) digits? I much appreciate your assistance in advance!
 

Ask a Question

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.

Ask a Question

Similar Threads

REPLACE command drops leading zeros 4
Another Leading Zero Question 7
Need 7 digit number with differnt number of leading zeros 10
Using REPLACE command removes leading zeros 2
In Excel find 5 digit number and replace with leading zero 2
Zip Codes Dropping Leading Zero 3
Autonumber field in Excel that behaves the same as Access 0
Need to add character before leading zero in a field 7

Top