If they aren't showing up in the formula bar they aren't there. You probably
have a custom format of "000000000" or something similar. To append the
zero's you can use this function:

=CONCATENATE(REPT("0",9-LEN(A1)),A1)


--
Regards,
Dave


"Debbie" wrote:

I am working on an excel spreadsheet where I was provided a list of Social
Security Numbers. The SSN's that lead with zeros show up in the cell with
the proper nine digit specification (no dashes or anything), because I
formatted it to text. However, in the formula bar (where it counts), it does
not show the leading zeros.

How can I get the formula bar to show all nine digits including the leading
zeros?

Thanks!