Excel Formatting
 

I have 2 sets of data/columns that I'm formatting to show 7 digits (e.g. 5240
becomes 0005420). I'm concatenating this with another column of 1-3 digits
but when I concatenate I'm loosing the leading zeros which I still need (the
# becomes 15240 instead of 10005240). Any ideas of how I can get the leading
zero's to stay? Thx.

Excel Formatting
 

=text(A1,"0000000") & text(B1,"0000000")
Bob Umlas
Excel MVP

"Darin" wrote:

I have 2 sets of data/columns that I'm formatting to show 7 digits (e.g. 5240
becomes 0005420). I'm concatenating this with another column of 1-3 digits
but when I concatenate I'm loosing the leading zeros which I still need (the
# becomes 15240 instead of 10005240). Any ideas of how I can get the leading
zero's to stay? Thx.