{"id":754,"date":"2018-06-30T16:59:19","date_gmt":"2018-06-30T16:59:19","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=754"},"modified":"2024-03-14T11:44:36","modified_gmt":"2024-03-14T11:44:36","slug":"custom-number-formatting","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/custom-number-formatting\/","title":{"rendered":"Custom Number Formatting"},"content":{"rendered":"\n
When you have numerical values in your worksheet, and you want to format them in a specific way that is not present in the default format types, you can always create your own by using the Custom Formatting <\/strong>feature.<\/p>\n\n\n\n You probably noticed that such numbers as phone numbers or social security numbers are divided into small portions, usually separated by spaces or hyphens.<\/p>\n\n\n\n That\u2019s because the human brain is actually better at remembering a larger number of digits or characters when they are divided into small groups.<\/p>\n\n\n\n In Excel, you don\u2019t have to create a new format for zip code, social security number, or phone number. But sometimes you need to work with other formats, for example, VAT identification number. You won’t find it in Excel, you have to create your own.<\/p>\n\n\n\n Look at the following example. You have two names with two VAT identification numbers.<\/p>\n\n\n\nExample 1:<\/h3>\n\n\n\n