Can Excel format Zip codes and Social Security numbers in various ways?

Yes, these types of special numbers can be formatted by choosing: Format>Number>Special menus from the Menu bar.