When I concatenate a number with leading zeros, the zeros are removed. How can I retain them?
D Dick Jan 31, 2008 #1 When I concatenate a number with leading zeros, the zeros are removed. How can I retain them?
B Beege Jan 31, 2008 #2 Dick said: When I concatenate a number with leading zeros, the zeros are removed. How can I retain them? Click to expand... Dick, Try & TEXT(A1,"00000") when concatenating? Beege
Dick said: When I concatenate a number with leading zeros, the zeros are removed. How can I retain them? Click to expand... Dick, Try & TEXT(A1,"00000") when concatenating? Beege
G Gord Dibben Jan 31, 2008 #3 If the numbers have leading zeros they are already text so should not drop the zeros. Unless, of course, the numbers are just formatted to show leading zeros. In that case =TEXT(G7,"000000")&TEXT(G8,"000000") Gord Dibben MS Excel MVP
If the numbers have leading zeros they are already text so should not drop the zeros. Unless, of course, the numbers are just formatted to show leading zeros. In that case =TEXT(G7,"000000")&TEXT(G8,"000000") Gord Dibben MS Excel MVP
