Format > Cells > Number > Special, Social security number, or Format > Cells > Number > Custom 000000000
Or store the numbers as text (perfectly legit for this application), and suppress the error: Tools > Options > Error Checking, uncheck Number stored as text.
Bookmarks