{"id":721,"date":"2013-03-20T07:47:51","date_gmt":"2013-03-20T07:47:51","guid":{"rendered":"http:\/\/excelvbatutor.com\/?p=721"},"modified":"2013-03-20T07:48:00","modified_gmt":"2013-03-20T07:48:00","slug":"formatting-functions-in-excel-vba","status":"publish","type":"post","link":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/","title":{"rendered":"Formatting Functions in Excel VBA"},"content":{"rendered":"<p>Formatting output is a very important part of Excel VBA programming so that the data can be presented systematically and clearly to the users. Data in the previous lesson were presented fairly systematically through the use offunctions like Int, Fix and Round. However, to have better control of the output format, we can use a number of formatting functions in Excel VBA.<\/p>\n<p>Read more about formatting functions at:<\/p>\n<p><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-9\/\">http:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-9\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formatting output is a very important part of Excel VBA programming so that the data can be presented systematically and clearly to the users. Data in the previous lesson were presented fairly systematically through the use offunctions like Int, Fix and Round. However, to have better control of the output format, we can use a &hellip; <a href=\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Formatting Functions in Excel VBA&#8221;<\/span><\/a><\/p>\n","protected":false},"author":5012,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-721","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Formatting Functions in Excel VBA<\/title>\n<meta name=\"description\" content=\"This is an excel Vba Article about formatting functions\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formatting Functions in Excel VBA\" \/>\n<meta property=\"og:description\" content=\"This is an excel Vba Article about formatting functions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-20T07:47:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-03-20T07:48:00+00:00\" \/>\n<meta name=\"author\" content=\"Liew Voon Kiong\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liew Voon Kiong\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\"},\"author\":{\"name\":\"Liew Voon Kiong\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"headline\":\"Formatting Functions in Excel VBA\",\"datePublished\":\"2013-03-20T07:47:51+00:00\",\"dateModified\":\"2013-03-20T07:48:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\"},\"wordCount\":79,\"commentCount\":0,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\",\"name\":\"Formatting Functions in Excel VBA\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"datePublished\":\"2013-03-20T07:47:51+00:00\",\"dateModified\":\"2013-03-20T07:48:00+00:00\",\"author\":{\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\"},\"description\":\"This is an excel Vba Article about formatting functions\",\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formatting Functions in Excel VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelvbatutor.com\/#website\",\"url\":\"https:\/\/excelvbatutor.com\/\",\"name\":\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"description\":\"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a\",\"name\":\"Liew Voon Kiong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/excelvbatutor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g\",\"caption\":\"Liew Voon Kiong\"},\"url\":\"https:\/\/excelvbatutor.com\/index.php\/author\/ajs7051vba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formatting Functions in Excel VBA","description":"This is an excel Vba Article about formatting functions","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:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/","og_locale":"en_US","og_type":"article","og_title":"Formatting Functions in Excel VBA","og_description":"This is an excel Vba Article about formatting functions","og_url":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","article_published_time":"2013-03-20T07:47:51+00:00","article_modified_time":"2013-03-20T07:48:00+00:00","author":"Liew Voon Kiong","twitter_misc":{"Written by":"Liew Voon Kiong"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#article","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/"},"author":{"name":"Liew Voon Kiong","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"headline":"Formatting Functions in Excel VBA","datePublished":"2013-03-20T07:47:51+00:00","dateModified":"2013-03-20T07:48:00+00:00","mainEntityOfPage":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/"},"wordCount":79,"commentCount":0,"articleSection":["General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/","url":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/","name":"Formatting Functions in Excel VBA","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"datePublished":"2013-03-20T07:47:51+00:00","dateModified":"2013-03-20T07:48:00+00:00","author":{"@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a"},"description":"This is an excel Vba Article about formatting functions","breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/2013\/03\/20\/formatting-functions-in-excel-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Formatting Functions in Excel VBA"}]},{"@type":"WebSite","@id":"https:\/\/excelvbatutor.com\/#website","url":"https:\/\/excelvbatutor.com\/","name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.","inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/43d141df324e8eb01509c5f5d8a4a76a","name":"Liew Voon Kiong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/excelvbatutor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3e3750a9c46828b988fc9432ec548bc847e79637d0971da3f409da2ec81297df?s=96&d=mm&r=g","caption":"Liew Voon Kiong"},"url":"https:\/\/excelvbatutor.com\/index.php\/author\/ajs7051vba\/"}]}},"_links":{"self":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/users\/5012"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/comments?post=721"}],"version-history":[{"count":2,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/721\/revisions"}],"predecessor-version":[{"id":723,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/posts\/721\/revisions\/723"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}