Leading zeros

[shariefi]

I have a column of numbers in a spreadsheet that are five, six or seven digits in length, and they need to be updated to all be eight digits in length by inserting leading zeros.

Is there a simple function I can write that will do this
Thanks!

 

[Joe4]

Let's say the value is in cell A1. Then here is one formula that will work:
=LEFT("00000000",8-LEN(A1)) & A1

Of course, if you just need it for visual purposes, you could simply do a custom format of: 00000000

 

[Joe4]

Per forum rules, please do not double-post the same question.

http://www.mrexcel.com/board2/viewtopic.php?t=237676