How do i zero pad when using combination of text and numbers?
 

i have a column of numbers.i want a combination of text and the column of
numbers in another column.Text being constant as "Group"
Reqd: groupxx where xx is the column of numbers
so for the combination, i type ="group"&LEFT(E5,2)
E being the column 5 being the row.
But i donot get the single digits zero padded.
for ex: i have 00,01,02,03...in the column of numbers and i get
group1,group2,group3 as result by apply above formula.
how do i get the zero padding?

How do i zero pad when using combination of text and numbers?
 

="group"&TEXT(LEFT(E5,2),"00")
or if E5 has only a number value
="group"&TEXT(E5,"00")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"kiran cherukumilli" <kiran wrote in
message ...
i have a column of numbers.i want a combination of text and the column of
numbers in another column.Text being constant as "Group"
Reqd: groupxx where xx is the column of numbers
so for the combination, i type ="group"&LEFT(E5,2)
E being the column 5 being the row.
But i donot get the single digits zero padded.
for ex: i have 00,01,02,03...in the column of numbers and i get
group1,group2,group3 as result by apply above formula.
how do i get the zero padding?