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

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How add a digit to front of number in each cell in excexl column 1
How do I stop Excel from dropping leading zeros? 9
Covert 9 digits to 10 in excel 2
How do I get a column with 12 digit numbers to only show the 1st 1 1
last 2 digits 2
How do I compare the stored data in micro 3
duplicate numbers in a column 2
Excel Changes My Last Digit to Zero 1

Top