D
Debbie
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!
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!