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.
Some examples
• 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.