Keep my leading zeros

  • Thread starter Thread starter Betty Csehi
  • Start date Start date
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!
 
Sounds like column B has been custom formatted to show the zeros.

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


Gord Dibben MS Excel MVP
 
Back
Top