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
 
Top