Please do NOT multi-post - you have answers elsewhere.

Pete

On Jun 24, 12:24*pm, Muthalaly
wrote:
Hi,
I am trying to concatenate two fields in excel.In this, one field is a custom
number field .When I am doing the concatenation I am losing the zeros before
the number.
Example 00123 + abc in this case I am getting a result of 123abc .But I am
looking
forward to get 00123abc. Is it possible in excel?Please help.