How to format numbers the way you want in Excel
You can make excel to format numbers the way you want using “format cell.
Select the cell with number you want to format and presst ctrl+1 or
right mouse click then choose format cells
Go to Number tab in the dialog box.
Select “custom” category and enter format as 000000 00000 (6 zeros followed by a space and then five more zeros)
Click ok to set the format to display locker number as you need it to be.
• For a social security number (SSN) format, enter 000-00-0000
• For phone number format, enter 000-000-0000
• For phone number with 1 digit country code format, enter (+0) 000 000 0000,
• For 2 digit country codes you can try (+00) 000 000 0000.