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!