Leading zero is suppressed when I merge 2 cells

J

Jeff

When i merge two cells i get this example:

A1 B1 C1
124 05 1245

What I want is this:

A1 B1 C1
124 05 12405

I used this formula to merge A1 & B1 but it supresses the
leading zeros in column B
 
J

JulieD

Hi Jeff

i'm guessing its because the 05 is displayed through cell formatting (custom
number format of "00") rather than actually being there in the cell .. in
this case try
=A1 & text(b1,"00")

Cheers
JulieD
 
Top