C
capxc
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,
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,