Keep my leading zeros

B

Betty Csehi

In col A I have ABC
In Col B I have 001234
My formula in Col C is A1&B1. The resulting answer is ABC1234. I want it
to keep the leading zeros so it reads ABC001234. Is there any way that I
can easily do this?
Thanks!
 
G

Gord Dibben

Sounds like column B has been custom formatted to show the zeros.

In C1 enter =A1 & TEXT(B1,"000000")


Gord Dibben MS Excel MVP
 

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

Find largest value in column with 2 criteria 1
Put parts of cell into separate columns 3
Counting unique values in multiple columns 4
Nested IF conditions 3
displaying leading zeros 3
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Force leading zeros 2
count all cells containing "Blue" 5

Top