leading 0's stripped

Is there any way to add back into a column leading 0's that have been stripped during an extract. Basically we have a column, all should be in a 8 character numerical sequence. However those beginning with 0's have been stripped down to 7 characters. How could I reformat those (i.e. if 7 characters long add a leading 0).
LVL 3
pma111Asked:
Who is Participating?
 
Brian PierceConnect With a Mentor PhotographerCommented:
Select Format-Cells-Custom and type 00000000
0
 
Naresh PatelConnect With a Mentor TraderCommented:
try this
=IF(LEN(A1)=7,"0"&A1,A1)

Open in new window


Thanks
0
 
SteveConnect With a Mentor Commented:
Try:

=TEXT(A1,"00000000")

Then copy down the rows.
Then copy and paste special values back over the original range.

Or
format the range using a custom format of "00000000"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.