Excel Formatting

D

Darin

I have 2 sets of data/columns that I'm formatting to show 7 digits (e.g. 5240
becomes 0005420). I'm concatenating this with another column of 1-3 digits
but when I concatenate I'm loosing the leading zeros which I still need (the
# becomes 15240 instead of 10005240). Any ideas of how I can get the leading
zero's to stay? Thx.
 

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

Top