How do I determine the number of digits in a cell

[Gandalf2524]

I have a column of numbers formatted as text. I need to find cells with only 5 digits and prefix a leading "0". How do I prefix a leading "0" to a cell with 5 digits but not cells with 6 digits? Each cell will have either 5 or 6 digits. I need all numbers to have 6 digits

Each cell contains the last 6 (or 5) digits of a longer serial number, which is also formatted as text. Right now, I am prefixing the "0" manually but this will get out of hand quickly.

Any suggestions will be greatly appreciated.

thank you
Gandalf2524

[jindon]

Change column reference/starting row to suite.

Please Login or Register  to view this content.

[AlKey]

Here is how you can do this by formula.

Assuming your data in column "A"

=TEXT(A1,"000000")

This will add a leading "0" for cells with 5 digits.

Also you can highlight data in column "A", go to Format Cells and select Custom and type in 000000
This format will add leading "0" to cells with 5 digits.

[Gandalf2524]

AlKey

Your suggestion worked great. Thanks.

Spencer