How to avoid value losing zero in front of digits??
 

I have a column D formated to 12 digit so that the values that have 11 digit
have 0 added in front of them to make them 12 digit.

Then I applied another formula ="01KF9H"&D.. in order to 01KF9H in front of
the 12 digits values in the column. When I copied the formula, I notice that
those digits with 0 in front of them lost the 0 and turned back to 11
digits. How do i make that column keep all the 12 digits values when adding
the new formula?

Please teach me.
Sincerely,
--
capxc

How to avoid value losing zero in front of digits??
 

="01KF9H"&text(d1,"000000000000")
or
="01KF9H"&text(d1,rept(0,12))



capxc wrote:

I have a column D formated to 12 digit so that the values that have 11 digit
have 0 added in front of them to make them 12 digit.

Then I applied another formula ="01KF9H"&D.. in order to 01KF9H in front of
the 12 digits values in the column. When I copied the formula, I notice that
those digits with 0 in front of them lost the 0 and turned back to 11
digits. How do i make that column keep all the 12 digits values when adding
the new formula?

Please teach me.
Sincerely,
--
capxc

--

Dave Peterson