{"id":12072,"date":"2022-11-04T10:28:04","date_gmt":"2022-11-04T10:28:04","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=12072"},"modified":"2024-02-19T14:52:19","modified_gmt":"2024-02-19T14:52:19","slug":"convert-numbers-to-text-with-commas","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/","title":{"rendered":"Convert Numbers to Text With Commas in Excel"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-159bcf16-c308-4b95-8146-c38805f4da4d\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Convert-Numbers-to-Text-With-Commas.xlsx\">Convert-Numbers-to-Text-With-Commas<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Convert-Numbers-to-Text-With-Commas.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-159bcf16-c308-4b95-8146-c38805f4da4d\">Download File<\/a><\/div>\n\n\n\n<p>Suppose you have a dataset in Excel that has long numbers. To improve readability, you may want to convert the numbers to text with commas. This tutorial shows three methods of converting numbers to text with commas in Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to Convert Numbers to Text with Commas in Excel<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Method 1: Use the TEXT Function<\/h3>\n\n\n\n<p>The first method is the use of the <strong>TEXT<\/strong> function.<\/p>\n\n\n\n<p>Suppose we have the following dataset that has long numbers in column A.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"132\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-12073\"\/><\/figure>\n\n\n\n<p>We want these numbers converted to text with commas in column B.<\/p>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol>\n<li>Select cell B2 and type in the formula below:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>=TEXT(A2,\"#,#\")<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"239\" height=\"132\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-12.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-12074\"\/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press Enter on the keyboard or click the Enter button on the formula bar.<\/li>\n\n\n\n<li>Double-click or drag down the fill handle to <a href=\"https:\/\/officetuts.net\/excel\/vba\/copy-formula-down-in-vba\/\">copy the formula down the column<\/a>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"235\" height=\"130\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/text-table-description-automatically-generated.png\" alt=\"Text, table\n\nDescription automatically generated\" class=\"wp-image-12075\"\/><\/figure>\n\n\n\n<p>The values in column B are left-aligned meaning they are text strings.<\/p>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TEXT(A2,\"#,#\")<\/code><\/pre>\n\n\n\n<p>The TEXT function converts the number in cell A2 to text with commas in the custom number format specified by the code \u201c#,#\u201d.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Method 2: Use the FIXED Function<\/h3>\n\n\n\n<p>The second method is the use of the <strong>FIXED<\/strong> function.<\/p>\n\n\n\n<p>Suppose we have the following dataset that has long numbers in column A.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"132\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12072-4.png\" alt=\"\" class=\"wp-image-12076\"\/><\/figure>\n\n\n\n<p>We want these numbers converted to text with commas in column B.<\/p>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol>\n<li>Select cell B2 and type in the following formula:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>=FIXED(A2,0,)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"237\" height=\"129\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-13.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-12077\"\/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press Enter on the keyboard or click the Enter button on the formula bar.<\/li>\n\n\n\n<li>Double-click or drag down the fill handle to copy the formula down the column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"235\" height=\"132\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/word-image-12072-6.png\" alt=\"\" class=\"wp-image-12078\"\/><\/figure>\n\n\n\n<p>The values in column B are left-aligned meaning they are text values.<\/p>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=FIXED(A2,0,)<\/code><\/pre>\n\n\n\n<p>The FIXED function rounds the number in cell A2 to 0 (zero) number of decimals and returns the result as text with commas.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Method 3: Use the DOLLAR Function<\/h3>\n\n\n\n<p>The third method is the use of the <strong>DOLLAR<\/strong> function.<\/p>\n\n\n\n<p>Suppose we have the following dataset that has long numbers in column A.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"238\" height=\"132\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-14.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-12079\"\/><\/figure>\n\n\n\n<p>We want these numbers converted to text with commas in column B using the currency format.<\/p>\n\n\n\n<p>We use the steps below:<\/p>\n\n\n\n<ol>\n<li>Select cell B2 and type in the following formula:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>=DOLLAR(A2,0)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"239\" height=\"132\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-15.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-12080\"\/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press Enter on the keyboard or click the Enter button on the formula bar.<\/li>\n\n\n\n<li>Double-click or drag down the fill handle to copy the formula down the column.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"131\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/text-table-description-automatically-generated-1.png\" alt=\"Text, table\n\nDescription automatically generated\" class=\"wp-image-12081\"\/><\/figure>\n\n\n\n<p>The values in column B are left-aligned because they are text strings.<\/p>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=DOLLAR(A2,0)<\/code><\/pre>\n\n\n\n<p>The DOLLAR function converts the number in cell A2 to text with commas with 0 (zero) decimal points using the currency format.<\/p>\n\n\n\n<p><strong>Note:<\/strong> The settings on your computer determine the currency format used in the result returned by the DOLLAR function.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Free SEO add-in for Excel<\/h2>\n\n\n\n<p>You can use the <a href=\"https:\/\/officetuts.net\/\">add-in<\/a> to add commas to numbers. Here&#8217;s how it works:<\/p>\n\n\n\n<p>First, select the numbers to which you want to add commas.<\/p>\n\n\n\n<p>Click the icon:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"191\" height=\"134\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/graphical-user-interface-application-teams-desc.png\" alt=\"Graphical user interface, application, Teams\n\nDescription automatically generated\" class=\"wp-image-12082\"\/><\/figure>\n\n\n\n<p>It opens a menu to the right.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"272\" height=\"317\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/graphical-user-interface-application-description.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-12083\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/graphical-user-interface-application-description.png 272w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/graphical-user-interface-application-description-257x300.png 257w\" sizes=\"(max-width: 272px) 100vw, 272px\" \/><\/figure>\n\n\n\n<p>Select the option at the bottom and click <strong>Humanize<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"140\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-16.png\" alt=\"Table\n\nDescription automatically generated\" class=\"wp-image-12084\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Sometimes we may need <a href=\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\">to convert long numbers to text values with commas in Excel<\/a> to improve readability. This tutorial has explained three methods for converting numbers to text with commas in Excel.<\/p>\n\n\n\n<p>The first method is the use of the TEXT function, and the second method is the use of the FIXED function. The third technique is the use of the DOLLAR function.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Suppose you have a dataset in Excel that has long numbers. To improve readability, you may want to convert the numbers to text&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Convert Numbers to Text With Commas in Excel<\/title>\n<meta name=\"description\" content=\"Convert long numbers to text with commas in Excel using 3 methods. Learn how to use the TEXT function to improve readability.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Numbers to Text With Commas in Excel\" \/>\n<meta property=\"og:description\" content=\"Convert long numbers to text with commas in Excel using 3 methods. Learn how to use the TEXT function to improve readability.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-04T10:28:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:19+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Convert Numbers to Text With Commas in Excel\",\"datePublished\":\"2022-11-04T10:28:04+00:00\",\"dateModified\":\"2024-02-19T14:52:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/\"},\"wordCount\":557,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png\",\"keywords\":[\"file\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/\",\"name\":\"Convert Numbers to Text With Commas in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png\",\"datePublished\":\"2022-11-04T10:28:04+00:00\",\"dateModified\":\"2024-02-19T14:52:19+00:00\",\"description\":\"Convert long numbers to text with commas in Excel using 3 methods. Learn how to use the TEXT function to improve readability.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert Numbers to Text With Commas in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert Numbers to Text With Commas in Excel","description":"Convert long numbers to text with commas in Excel using 3 methods. Learn how to use the TEXT function to improve readability.","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:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/","og_locale":"en_US","og_type":"article","og_title":"Convert Numbers to Text With Commas in Excel","og_description":"Convert long numbers to text with commas in Excel using 3 methods. Learn how to use the TEXT function to improve readability.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/","article_published_time":"2022-11-04T10:28:04+00:00","article_modified_time":"2024-02-19T14:52:19+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Convert Numbers to Text With Commas in Excel","datePublished":"2022-11-04T10:28:04+00:00","dateModified":"2024-02-19T14:52:19+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/"},"wordCount":557,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png","keywords":["file"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/","url":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/","name":"Convert Numbers to Text With Commas in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png","datePublished":"2022-11-04T10:28:04+00:00","dateModified":"2024-02-19T14:52:19+00:00","description":"Convert long numbers to text with commas in Excel using 3 methods. Learn how to use the TEXT function to improve readability.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated-11.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/convert-numbers-to-text-with-commas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Convert Numbers to Text With Commas in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12072"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=12072"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12072\/revisions"}],"predecessor-version":[{"id":15787,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12072\/revisions\/15787"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=12072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=12072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=12072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}