=TEXT(A1,"000000000")

HTH
Jason
Atlanta, GA

-----Original Message-----
What is the formula for the function MID to get lead 0s
to show like on a
social security number.

for example: I see right now 56769584 but I want to see
in the cell
056769584.
.