Concatenate column with leading zeros
 

I need to create a column with the entire UPC code of each item listed in
the item column, but when I concatenate the columns to form the UPC the
leading zeros in the UPC item colun are dropped.

I sthere a way around this?

Thanks in advance

Concatenate column with leading zeros
 

In A1:B1 I have text and number
apple 245 apple 000245
The formula in C1 is =A1&" "&TEXT(B1,"000000")
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/o...ult.aspx#tab=4

"Dick Stapleton" wrote in message
...
I need to create a column with the entire UPC code of each item listed in
the item column, but when I concatenate the columns to form the UPC the
leading zeros in the UPC item colun are dropped.

I sthere a way around this?

Thanks in advance