Leading zero is suppressed when I merge 2 cells

  • Thread starter Thread starter Jeff
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

How to merge Excel address columns when some zips begin with zeros 4
sorting two columns of merged cells 1
Conditional Concatenate? 2
Merged cells 1
Merged cells and formula data sources 10
merging 2 cells and adding a space. 1
need formula returning a blank cell 4
Combining a whole number and a % in one cell 1

Back
Top