{"id":24492,"date":"2020-01-10T20:28:53","date_gmt":"2020-01-10T14:58:53","guid":{"rendered":"https:\/\/mywindowshub.com\/?p=24492"},"modified":"2020-02-21T00:43:57","modified_gmt":"2020-02-20T19:13:57","slug":"how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro","status":"publish","type":"post","link":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/","title":{"rendered":"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?"},"content":{"rendered":"\n<p>In this article, I shall show you how to change the Phone number formatting in MS Excel sheet, using VBA macros. You have to create a Macro for this. Before that, check out <a href=\"https:\/\/mywindowshub.com\/why-vba-is-becoming-a-necessity-for-every-professional-microsoft-office-user\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"what is VBA and why is it important (opens in a new tab)\">what is VBA and why is it important<\/a>?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro<\/h2>\n\n\n\n<p>Let me create a small table for you, which consists of name and phone numbers. For that, you have to select Phone number as the special category. By default, the phone number category is always for the United States, that is, (###)###-###. So, if you enter a 10 digit number for another country, e.g. India, you have to change the formatting style, otherwise the number you entered will indicate an US phone number.   <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/VBAmacro-num-1.jpg\" alt=\"To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro\"\/><\/figure>\n\n\n\n<p>The table I created is very small, so you may not be able to understand the point of creating a macro. But in real cases, the Excel sheets consist of thousands of rows and a macro will definitely solve your problem much easily. In the table, you see there are some phone numbers, whose formatting are for United States. Suppose I want to change the formatting to that of India. Let&#8217;s see how to do it. <\/p>\n\n\n\n<p> First, you have to <a rel=\"noreferrer noopener\" href=\"https:\/\/mywindowshub.com\/how-to-turn-on-the-developer-tab-in-ms-excel-for-vba\/\" target=\"_blank\">turn on the Developer Tab in MS Excel<\/a>. <\/p>\n\n\n\n<p>Next, click on the Developer tab and turn on the <strong>Use Relative Reference<\/strong>s. Before selecting Record Macro, select a cell. Now, select <strong>Record Macro<\/strong>.   <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/VBAmacro-num-2.jpg\" alt=\"To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro\"\/><\/figure>\n\n\n\n<p>Give a name for Macro, enter a shortcut and click OK.    <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/VBAmacro-num-3.jpg\" alt=\"To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro\"\/><\/figure>\n\n\n\n<p>The Macro Recording has started. Go to Home tab in the Ribbon, click on the More Options drop down arrow just below the Number tab.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/VBAmacro-num-4.jpg\" alt=\"To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro\"\/><\/figure>\n\n\n\n<p>As the Number tab opens, select the <strong>Custom<\/strong> option in the left tab. In the right, under the <strong>Type<\/strong> menu, the format is given. Delete it and change it to your preferred format. For India, my required format is (+91)########## where (+91) is India&#8217;s ISD code and the 10 hashes represent 10 digits of a number. Finally, click on OK.   <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/VBAmacro-num-5.jpg\" alt=\"To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro\"\/><\/figure>\n\n\n\n<p>Finally, go to the Developer tab, and click on <strong>Stop Recording<\/strong>.   <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/VBAmacro-num-6.jpg\" alt=\"To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro\"\/><\/figure>\n\n\n\n<p>Your Macro is now created. To apply to all the cells of a column, press <strong>Ctrl+Shift+Down_Arrow<\/strong> to select all cells of the column. Now click the shortcut of the macro, in my case, it is <strong>Ctrl+Shift+U<\/strong>.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/VBAmacro-num-7.jpg\" alt=\"To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro\"\/><\/figure>\n\n\n\n<p>That&#8217;s all!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Read More: <a rel=\"noreferrer noopener\" href=\"https:\/\/mywindowshub.com\/list-of-all-excel-vba-tutorials-in-mywindowshub-com\/\" target=\"_blank\">List Of All Excel VBA Tutorials<\/a><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>In this article, I shall show you how to change the Phone number formatting in MS Excel sheet, using VBA macros. You have to create a Macro for this. Before that, check out what is VBA and why is it important? Steps To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":24498,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[253,254],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?<\/title>\n<meta name=\"description\" content=\"In this article, I shall show you to change phone number formatting of Phone numbers in an Excel sheet using VBA macro.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?\" \/>\n<meta property=\"og:description\" content=\"In this article, I shall show you to change phone number formatting of Phone numbers in an Excel sheet using VBA macro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/\" \/>\n<meta property=\"og:site_name\" content=\"My Windows Hub\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-10T14:58:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-20T19:13:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2020\/01\/VBAmacro-num-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"947\" \/>\n\t<meta property=\"og:image:height\" content=\"543\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Debaleena\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Debaleena\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/\"},\"author\":{\"name\":\"Debaleena\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44\"},\"headline\":\"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?\",\"datePublished\":\"2020-01-10T14:58:53+00:00\",\"dateModified\":\"2020-02-20T19:13:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/\"},\"wordCount\":415,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/mywindowshub.com\/#organization\"},\"articleSection\":[\"MS Office Guide\",\"VBA For Office\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/\",\"url\":\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/\",\"name\":\"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?\",\"isPartOf\":{\"@id\":\"https:\/\/mywindowshub.com\/#website\"},\"datePublished\":\"2020-01-10T14:58:53+00:00\",\"dateModified\":\"2020-02-20T19:13:57+00:00\",\"description\":\"In this article, I shall show you to change phone number formatting of Phone numbers in an Excel sheet using VBA macro.\",\"breadcrumb\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mywindowshub.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mywindowshub.com\/#website\",\"url\":\"https:\/\/mywindowshub.com\/\",\"name\":\"My Windows Hub\",\"description\":\"Windows tutorials, themes, news and updates\",\"publisher\":{\"@id\":\"https:\/\/mywindowshub.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mywindowshub.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/mywindowshub.com\/#organization\",\"name\":\"mywindowshub.com\",\"url\":\"https:\/\/mywindowshub.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png\",\"contentUrl\":\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png\",\"width\":494,\"height\":149,\"caption\":\"mywindowshub.com\"},\"image\":{\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44\",\"name\":\"Debaleena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g\",\"caption\":\"Debaleena\"},\"description\":\"Happiness is that best therapy. Use it to heal yourself and then others!\",\"sameAs\":[\"http:\/\/warbleoflife.blogspot.in\/\"],\"url\":\"https:\/\/mywindowshub.com\/author\/debaleena\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?","description":"In this article, I shall show you to change phone number formatting of Phone numbers in an Excel sheet using VBA macro.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/","og_locale":"en_US","og_type":"article","og_title":"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?","og_description":"In this article, I shall show you to change phone number formatting of Phone numbers in an Excel sheet using VBA macro.","og_url":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/","og_site_name":"My Windows Hub","article_published_time":"2020-01-10T14:58:53+00:00","article_modified_time":"2020-02-20T19:13:57+00:00","og_image":[{"width":947,"height":543,"url":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2020\/01\/VBAmacro-num-7.png","type":"image\/png"}],"author":"Debaleena","twitter_misc":{"Written by":"Debaleena","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#article","isPartOf":{"@id":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/"},"author":{"name":"Debaleena","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44"},"headline":"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?","datePublished":"2020-01-10T14:58:53+00:00","dateModified":"2020-02-20T19:13:57+00:00","mainEntityOfPage":{"@id":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/"},"wordCount":415,"commentCount":0,"publisher":{"@id":"https:\/\/mywindowshub.com\/#organization"},"articleSection":["MS Office Guide","VBA For Office"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/","url":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/","name":"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?","isPartOf":{"@id":"https:\/\/mywindowshub.com\/#website"},"datePublished":"2020-01-10T14:58:53+00:00","dateModified":"2020-02-20T19:13:57+00:00","description":"In this article, I shall show you to change phone number formatting of Phone numbers in an Excel sheet using VBA macro.","breadcrumb":{"@id":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mywindowshub.com\/how-to-change-phone-number-formatting-of-phone-numbers-in-an-excel-sheet-using-vba-macro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mywindowshub.com\/"},{"@type":"ListItem","position":2,"name":"How To Change Phone Number Formatting Of Phone Numbers In An Excel Sheet Using VBA Macro?"}]},{"@type":"WebSite","@id":"https:\/\/mywindowshub.com\/#website","url":"https:\/\/mywindowshub.com\/","name":"My Windows Hub","description":"Windows tutorials, themes, news and updates","publisher":{"@id":"https:\/\/mywindowshub.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mywindowshub.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/mywindowshub.com\/#organization","name":"mywindowshub.com","url":"https:\/\/mywindowshub.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/","url":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png","contentUrl":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png","width":494,"height":149,"caption":"mywindowshub.com"},"image":{"@id":"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44","name":"Debaleena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g","caption":"Debaleena"},"description":"Happiness is that best therapy. Use it to heal yourself and then others!","sameAs":["http:\/\/warbleoflife.blogspot.in\/"],"url":"https:\/\/mywindowshub.com\/author\/debaleena\/"}]}},"_links":{"self":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/24492"}],"collection":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/comments?post=24492"}],"version-history":[{"count":9,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/24492\/revisions"}],"predecessor-version":[{"id":24752,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/24492\/revisions\/24752"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/media\/24498"}],"wp:attachment":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/media?parent=24492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/categories?post=24492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/tags?post=24492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}