Link loses formatting
 

I have two cells, the first is suppose to be four characters and the second
is suppose to be six. These two cells are combined into a third cell.

Sometimes people don't enter the full six digits so I changed the cell
formatting so that it pre-fills zeros when people forget.

However when these are copied over to the new cell the pre-filled zeros are
lost.

The formula in the third cell is ...

=IF(B10="","",$B$2&B10)

If B2 is 1234 and B10 is 000123 I would like the new cell to be 1234000123
but it only shows 1234123 and loses the pre-filled zeros.

Does any of this make sense?

Does anyone have any ideas?

Link loses formatting
 

=IF(B10="","",$B$2&text(B10,"000000"))

Do you need =text() around the B2, too?

FrankM wrote:

I have two cells, the first is suppose to be four characters and the second
is suppose to be six. These two cells are combined into a third cell.

Sometimes people don't enter the full six digits so I changed the cell
formatting so that it pre-fills zeros when people forget.

However when these are copied over to the new cell the pre-filled zeros are
lost.

The formula in the third cell is ...

=IF(B10="","",$B$2&B10)

If B2 is 1234 and B10 is 000123 I would like the new cell to be 1234000123
but it only shows 1234123 and loses the pre-filled zeros.

Does any of this make sense?

Does anyone have any ideas?

--

Dave Peterson

Link loses formatting
 

THAT'S EXACTLY WHAT I NEEDED !!!!!!!!!

"Dave Peterson" wrote:

=IF(B10="","",$B$2&text(B10,"000000"))

Do you need =text() around the B2, too?

FrankM wrote:

I have two cells, the first is suppose to be four characters and the second
is suppose to be six. These two cells are combined into a third cell.

Sometimes people don't enter the full six digits so I changed the cell
formatting so that it pre-fills zeros when people forget.

However when these are copied over to the new cell the pre-filled zeros are
lost.

The formula in the third cell is ...

=IF(B10="","",$B$2&B10)

If B2 is 1234 and B10 is 000123 I would like the new cell to be 1234000123
but it only shows 1234123 and loses the pre-filled zeros.

Does any of this make sense?

Does anyone have any ideas?

--

Dave Peterson