formula for all values to be 13 digits

[psrs0810]

I have a list of values that vary for 9 digits to 13 digits. I need all of those values to be 13 digits. For those that are not 13 digits to add a leading 0/0's in front.

 

[psrs0810]

I got it: =RIGHT(CONCATENATE("0000000000000",C2),13)

I had my formula backwards before

 

[Jonmo1]

You can do

=TEXT(A1,"0000000000000")

Just note that the values are no longer numbers, they are just text strings.

Hope that helps.

 

[VoG]

Try selecting the numbers then running

Sub AddZero()
Dim c As Range
For Each c In Selection
    c.NumberFormat = "@"
    c.Value = WorksheetFunction.Rept("0", 13 - Len(c.Value)) & c.Value
Next c
End Sub

 

[psrs0810]

I'll try them out. Thanks guys