{"id":5087,"date":"2017-12-23T10:09:41","date_gmt":"2017-12-23T10:09:41","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=5087"},"modified":"2023-11-14T18:31:28","modified_gmt":"2023-11-14T18:31:28","slug":"excel-text-function-8-examples-convert-number-date-text","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/","title":{"rendered":"TEXT Function in Excel"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9822\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-TEXT-function.jpg\" alt=\"Visual Tutorial: Explore the Power of Excel TEXT Function - Learn to Create Customized Text Formats for Numbers and Dates with this Comprehensive Infographic.\" width=\"1000\" height=\"630\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-TEXT-function.jpg 1000w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-TEXT-function-300x189.jpg 300w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-TEXT-function-768x484.jpg 768w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-TEXT-function-540x340.jpg 540w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<div class=\"has-left-border-and-background-color\">\n<p style=\"text-align: center;\"><strong>Excel TEXT Function<\/strong><\/p>\n<ul>\n<li>The Excel TEXT function can be used to convert numbers and dates into text.<\/li>\n<li>This is particularly useful for scenarios where you require displaying the numbers or dates with text strings.<\/li>\n<li>You may also use the TEXT function for formatting dates.<\/li>\n<li>Generally, the TEXT function is used with other functions. For example,<\/li>\n<\/ul>\n<div class=\"codediv\">=CONCATENATE(\"Event starting at \",TEXT(A4,\"mm\/dd\/yyyy\"))<\/div>\n<\/div>\n<h3><strong>Syntax of using the TEXT function<\/strong><\/h3>\n<p>The general syntax for using the TEXT function in Excel:<\/p>\n<div class=\"codediv\">=TEXT(Value to convert into text, \"Formatting code\")<\/div>\n<table width=\"887\">\n<tbody>\n<tr>\n<td width=\"362\"><span style=\"color: #008000;\"><strong>Argument<\/strong><\/span><\/td>\n<td width=\"525\"><span style=\"color: #008000;\"><strong>Description<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td>Value to convert into text<\/td>\n<td>In the first argument, you may provide a number, date, etc. to be converted into the text.<\/td>\n<\/tr>\n<tr>\n<td>Formatting code<\/td>\n<td>The formatting code like decimal points in numbers, date format, etc.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>By using formatting codes, you may format dates and times as per the requirement and locale.<\/p>\n<div class=\"note-div\"><strong>Note: <\/strong>The TEXT function is generally used in conjunction with other things e.g. CONCATENATE function, \u2018&amp;\u2019 concatenation character, etc. You will rarely be required to use this function by itself.<\/div>\n<h3><strong>A simple example of the TEXT function<\/strong><\/h3>\n<p>Let me start with a basic example of using TEXT function. In the A2 cell, a number is given while a date is given in the A3 cell. The TEXT function is used in B2 and B3 cells for converting the respective number and date into text:<\/p>\n<p>The B2 formula:<\/p>\n<div class=\"codediv\">=TEXT(A2,\"0\")<\/div>\n<p>The B3 formula:<\/p>\n<div class=\"codediv\">=TEXT(A3,\"MM\/DD\/YY\")<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5088\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.1-Excel-TEXT-function.png\" alt=\"Excel TEXT function\" width=\"387\" height=\"134\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.1-Excel-TEXT-function.png 387w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.1-Excel-TEXT-function-300x104.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/p>\n<p>The evidence that both are converted to text is the display of number and date in B2 and B3 cells as left aligned. By default, the number and date are aligned right as in the case of A2 and A3 cells.<\/p>\n<h3><strong>Display the day name of today by TEXT function<\/strong><\/h3>\n<p>The following example used the TODAY() function to get the current date and displayed the day name e.g. Tuesday, Wednesday by using the TEXT function:<\/p>\n<p>The TEXT formula:<\/p>\n<div class=\"codediv\">=TEXT(TODAY(),\"DDDD\")<\/div>\n<p>The result:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5089\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.2-TEXT-day-name.png\" alt=\"TEXT day name\" width=\"187\" height=\"125\" \/><\/p>\n<div class=\"info-div\"><strong>You may also like to learn:<\/strong> <a href=\"\/today-date-in-vba\/\">Excel VBA today's date<\/a><\/div>\n<h3><strong>Number with %, and two decimal points<\/strong><\/h3>\n<p>This example displays the specified A2 cell number with percentage and A3 cell with two decimal points with \u2018$\u2019 sign:<\/p>\n<p>The formula for B2:<\/p>\n<div class=\"codediv\">=TEXT(A2,\"0.0%\")<\/div>\n<p>For B3:<\/p>\n<div class=\"codediv\">=TEXT(A3,\"$#,##0.00\")<\/div>\n<p><strong>The result:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5090\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.3-TEXT-number-percentage.png\" alt=\"TEXT number percentage\" width=\"389\" height=\"129\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.3-TEXT-number-percentage.png 389w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.3-TEXT-number-percentage-300x99.png 300w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/p>\n<h3><strong>Display leading zeros for a number example<\/strong><\/h3>\n<p>By default, Excel will not display leading zeros for the numbers. For example, if you try entering the number 00525, Excel displays it as 525.<\/p>\n<p>The example below shows the leading zeros for numbers in different cells.<\/p>\n<p><strong>The TEXT formula:<\/strong><\/p>\n<div class=\"codediv\">=TEXT(A2,\"00000\")<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5091\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.4-TEXT-leading-zeros.png\" alt=\"TEXT leading zeros\" width=\"386\" height=\"143\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.4-TEXT-leading-zeros.png 386w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.4-TEXT-leading-zeros-300x111.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/p>\n<p>You may use more or less number of zeros \u2013 depending on the requirement.<\/p>\n<h3><strong>Display a thousand separators in numbers<\/strong><\/h3>\n<p>This example displays the numbers with 1000 separators. You may use <strong># or 0<\/strong> in the formatting code as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5092\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png\" alt=\"TEXT thousand seperator\" width=\"387\" height=\"145\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png 387w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato-300x112.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/p>\n<p><strong>The formula used in B2 for A2 number:<\/strong><\/p>\n<div class=\"codediv\">=TEXT(A2,\"#,###\")<\/div>\n<p><strong>The formula in B3:<\/strong><\/p>\n<div class=\"codediv\">=TEXT(A3,\"0,000\")<\/div>\n<p><strong>In B4:<\/strong><\/p>\n<div class=\"codediv\">=TEXT(A4,\"#,###.0\")<\/div>\n<h3><strong>The example of date formatting codes in TEXT function<\/strong><\/h3>\n<p>The following example shows using a few date formatting codes with the TEXT function.<\/p>\n<p>For the example, I have used the \u201c12\/20\/2016\u201d date and by using the TEXT function formatting code argument, the month number, month name in three letters, full month name, the day with and without leading zero, day name in three letters and full day name are displayed as follows:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5093\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.6-TEXT-Dates.png\" alt=\"TEXT Dates\" width=\"567\" height=\"317\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.6-TEXT-Dates.png 567w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.6-TEXT-Dates-300x168.png 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/p>\n<p>If you want to copy any of these formulas, these are listed below:<\/p>\n<table>\n<thead>\n<tr>\n<th>Formula<\/th>\n<th>Description<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>=TEXT(A4,\"mmm\")<\/code><\/td>\n<td>Short Month (e.g., Jan, Feb)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"mmmm\")<\/code><\/td>\n<td>Full Month Name (e.g., January)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"m\")<\/code><\/td>\n<td>Month Number (1-12)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"mm\")<\/code><\/td>\n<td>Month Number (01-12)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"ddd\")<\/code><\/td>\n<td>Short Day Name (e.g., Mon, Tue)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"dddd\")<\/code><\/td>\n<td>Full Day Name (e.g., Monday)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"dd\")<\/code><\/td>\n<td>Day Number (01-31)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"yy\")<\/code><\/td>\n<td>Short Year (two digits)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"yyyy\")<\/code><\/td>\n<td>Full Year (four digits)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div class=\"info-div\"><strong>Interested learning:<\/strong> <a href=\"\/4-ways-of-how-to-calculate-age-in-excel-years-months-and-days\/\">Age formula in Excel<\/a><\/div>\n<h3><strong>Format codes for time in TEXT function<\/strong><\/h3>\n<p>Similarly, you may use the format code argument in the TEXT function to display the time in your desired format. Like we used <strong>m, d, y<\/strong> variations for dates, the h, m, s, am\/pm are used for time formatting.<\/p>\n<p>The format code is case insensitive i.e. you may use <strong>h or H<\/strong> etc.<\/p>\n<p>See the following example with various formulas used to display time:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5094\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.7-Excel-TEXT-time.png\" alt=\"Excel TEXT time\" width=\"663\" height=\"379\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.7-Excel-TEXT-time.png 663w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.7-Excel-TEXT-time-300x171.png 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/p>\n<p>The following formulas are used for getting the time, hours, minutes, and seconds from the A4 cell (4:55 PM).<\/p>\n<table>\n<thead>\n<tr>\n<th>Formula<\/th>\n<th>Description<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>=TEXT(A4,\"h AM\/PM\")<\/code><\/td>\n<td>Time in AM\/PM format (e.g., 3 PM)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"h:mm AM\/PM\")<\/code><\/td>\n<td>Time in AM\/PM format with minutes (e.g., 3:15 PM)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"h:mm:ss\")<\/code><\/td>\n<td>Time in 24-hour format with seconds (e.g., 15:30:45)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"h\")<\/code><\/td>\n<td>Hours (0-23)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"hh\")<\/code><\/td>\n<td>Hours in 00-23 format<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"m\")<\/code><\/td>\n<td>Minutes (0-59)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"mm\")<\/code><\/td>\n<td>Minutes in 00-59 format<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"s\")<\/code><\/td>\n<td>Seconds (0-59)<\/td>\n<\/tr>\n<tr>\n<td><code>=TEXT(A4,\"ss\")<\/code><\/td>\n<td>Seconds in 00-59 format<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>An example of using TEXT function with CONCATENATE<\/strong><\/h3>\n<p>The example below shows using the TEXT function with the <a href=\"\/2-ways-concatenation-excel-5-examples-joining-stringscells\/\">CONCATENATE function<\/a>. For that, the date in A2 cell is converted to text and combined with a string by using the CONCATENATE function.<\/p>\n<p>To show the difference, the B2 displays the result by simply joining the A2 date without the TEXT function:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5095\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.8-Excel-TEXT-CONCATENATE.png\" alt=\"Excel TEXT CONCATENATE\" width=\"560\" height=\"108\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.8-Excel-TEXT-CONCATENATE.png 560w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.8-Excel-TEXT-CONCATENATE-300x58.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/p>\n<p>You see, the formatting of the date in A2 cell is removed in B2 as I simply used it in CONCATENATE function. The C2 displayed it correctly where this formula is used:<\/p>\n<div class=\"codediv\">=CONCATENATE(\"Event starting at\u00a0 \",TEXT(A2,\"mm\/dd\/yyyy\"))<\/div>\n<p><strong>The formula in B2:<\/strong><\/p>\n<div class=\"codediv\">=CONCATENATE(\"Event starting at \",A2)<\/div>\n<p>See another formula for displaying this date more elegantly:<\/p>\n<p>The formula:<\/p>\n<div class=\"codediv\">=CONCATENATE(\"Event starting at\u00a0 \",TEXT(A2,\"dddd d mmmm, yyyy\"))<\/div>\n<p><strong>The result:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5096\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.9-TEXT-CONCATENATE-2.png\" alt=\"TEXT CONCATENATE 2\" width=\"414\" height=\"101\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.9-TEXT-CONCATENATE-2.png 414w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.9-TEXT-CONCATENATE-2-300x73.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats. <\/p>\n","protected":false},"author":1,"featured_media":5092,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[142],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel TEXT function: 8 Examples to Convert Number and Date to Text<\/title>\n<meta name=\"description\" content=\"Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats. Enhance your Excel skills with step-by-step tutorials on Excel-learn.com\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel TEXT function: 8 Examples to Convert Number and Date to Text\" \/>\n<meta property=\"og:description\" content=\"Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats. Enhance your Excel skills with step-by-step tutorials on Excel-learn.com\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-23T10:09:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-14T18:31:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png\" \/>\n\t<meta property=\"og:image:width\" content=\"387\" \/>\n\t<meta property=\"og:image:height\" content=\"145\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"excelmaster\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"excelmaster\" \/>\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:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/\"},\"author\":{\"name\":\"excelmaster\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"headline\":\"TEXT Function in Excel\",\"datePublished\":\"2017-12-23T10:09:41+00:00\",\"dateModified\":\"2023-11-14T18:31:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/\"},\"wordCount\":883,\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png\",\"articleSection\":[\"Excel Functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/\",\"url\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/\",\"name\":\"Excel TEXT function: 8 Examples to Convert Number and Date to Text\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png\",\"datePublished\":\"2017-12-23T10:09:41+00:00\",\"dateModified\":\"2023-11-14T18:31:28+00:00\",\"description\":\"Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats. Enhance your Excel skills with step-by-step tutorials on Excel-learn.com\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png\",\"width\":387,\"height\":145,\"caption\":\"TEXT thousand seperator\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excel-learn.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TEXT Function in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.excel-learn.com\/#organization\",\"name\":\"Excel Tutorials\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"width\":227,\"height\":48,\"caption\":\"Excel Tutorials\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"},\"url\":\"https:\/\/www.excel-learn.com\/author\/jqueryaz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel TEXT function: 8 Examples to Convert Number and Date to Text","description":"Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats. Enhance your Excel skills with step-by-step tutorials on Excel-learn.com","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:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/","og_locale":"en_US","og_type":"article","og_title":"Excel TEXT function: 8 Examples to Convert Number and Date to Text","og_description":"Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats. Enhance your Excel skills with step-by-step tutorials on Excel-learn.com","og_url":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/","og_site_name":"Excel Tutorials","article_published_time":"2017-12-23T10:09:41+00:00","article_modified_time":"2023-11-14T18:31:28+00:00","og_image":[{"width":387,"height":145,"url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png","type":"image\/png"}],"author":"excelmaster","twitter_misc":{"Written by":"excelmaster","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#article","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/"},"author":{"name":"excelmaster","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3"},"headline":"TEXT Function in Excel","datePublished":"2017-12-23T10:09:41+00:00","dateModified":"2023-11-14T18:31:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/"},"wordCount":883,"publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"image":{"@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png","articleSection":["Excel Functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/","url":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/","name":"Excel TEXT function: 8 Examples to Convert Number and Date to Text","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage"},"image":{"@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png","datePublished":"2017-12-23T10:09:41+00:00","dateModified":"2023-11-14T18:31:28+00:00","description":"Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats. Enhance your Excel skills with step-by-step tutorials on Excel-learn.com","breadcrumb":{"@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#primaryimage","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/33.5-TEXT-thousand-seperato.png","width":387,"height":145,"caption":"TEXT thousand seperator"},{"@type":"BreadcrumbList","@id":"https:\/\/www.excel-learn.com\/excel-text-function-8-examples-convert-number-date-text\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excel-learn.com\/"},{"@type":"ListItem","position":2,"name":"TEXT Function in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.excel-learn.com\/#website","url":"https:\/\/www.excel-learn.com\/","name":"Excel Tutorials","description":"Tips, Solutions, Tricks","publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excel-learn.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.excel-learn.com\/#organization","name":"Excel Tutorials","url":"https:\/\/www.excel-learn.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","width":227,"height":48,"caption":"Excel Tutorials"},"image":{"@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3","name":"excelmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","caption":"excelmaster"},"url":"https:\/\/www.excel-learn.com\/author\/jqueryaz\/"}]}},"_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/5087"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=5087"}],"version-history":[{"count":5,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/5087\/revisions"}],"predecessor-version":[{"id":9827,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/5087\/revisions\/9827"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/5092"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=5087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=5087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=5087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}