By default, any leading zeroes in Social Security Numbers will be truncated when you view the file in Excel, but the full number remains available behind the scenes. To format this field to display all nine characters:
Highlight the SSN column.
Go to the Format menu and select Cells.
Under the Number heading, choose Custom.
Type nine zeroes in the available box (000000000).
Click OK.