How to format numbers the way you want in Excel

Home - Excel - How to format numbers the way you want in Excel
in

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.
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.
 
 

Recent News

Clients Reviews

Flickr Photos

Contact Us

176 queries in 3.321 seconds.