{"id":47465,"date":"2024-06-12T18:00:43","date_gmt":"2024-06-12T16:00:43","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=47465"},"modified":"2024-06-10T15:55:57","modified_gmt":"2024-06-10T13:55:57","slug":"format-numbers-as-text","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-numbers-as-text\/","title":{"rendered":"How to Format Numbers as Text in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Format-numbers-as-text.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-47733 size-large\" title=\"Format numbers as text\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Format-numbers-as-text-1024x576.png\" alt=\"Format numbers as text\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Format-numbers-as-text-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Format-numbers-as-text-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Format-numbers-as-text-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Format-numbers-as-text-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/Format-numbers-as-text.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nFormatting numbers as text in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a> is crucial for managing data that shouldn&#8217;t be altered by numerical calculations, such as phone numbers, zip codes, or product codes. By converting numbers to text, you ensure that leading zeros are preserved and the data is displayed exactly as intended. In this guide, we will cover different methods on how to format numbers as text.<\/p>\n<p><strong>Key Takeaways:<\/strong><\/p>\n<ul>\n<li>Proper formatting in Excel helps ensure data is presented clearly, aiding in better understanding and decision-making.<\/li>\n<li>Converting numbers to text is essential for data that shouldn&#8217;t be manipulated mathematically, like phone numbers or zip codes, and for preserving leading zeros.<\/li>\n<li>Adding an apostrophe before a number converts it to text quickly, making it ideal for small-scale adjustments.<\/li>\n<li>The TEXT function allows for detailed formatting of numbers into text, applying specific formats for dates, percentages, currencies, and more.<\/li>\n<li>Excel\u2019s &#8216;Text to Columns&#8217; feature enables efficient bulk conversion of numbers to text, streamlining the process for large datasets.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-numbers-as-text\/#Introduction_to_Formatting_in_Excel\" title=\"Introduction to Formatting in Excel\">Introduction to Formatting in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-numbers-as-text\/#Simple_Techniques_to_Convert_Numbers_to_Text\" title=\"Simple Techniques to Convert Numbers to Text\">Simple Techniques to Convert Numbers to Text<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-numbers-as-text\/#Working_Smarter_with_Excels_Tools\" title=\"Working Smarter with Excel&#8217;s Tools\">Working Smarter with Excel&#8217;s Tools<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-numbers-as-text\/#FAQs_All_About_Number-to-Text_Conversion_in_Excel\" title=\"FAQs: All About Number-to-Text Conversion in Excel\">FAQs: All About Number-to-Text Conversion in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction_to_Formatting_in_Excel\"><\/span>Introduction to Formatting in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>The Essentials of Number Formats<\/h3>\n<p>In the world of Excel, getting the format right can be just as crucial as the data itself. After all, how your numbers are displayed can dramatically impact understanding and decision-making. Excel offers a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/custom-number-formats-in-excel\/\" target=\"_blank\" rel=\"noopener\">plethora of formatting options<\/a>, ranging from basic to custom, allowing you to present your data clearly and effectively.<\/p>\n<p>Imagine you enter a number into a cell, and Excel mechanically applies the General format, showing the value exactly as typed\u2014unless it\u2019s a large number that gets displayed in scientific notation or a tiny cell that cuts off some digits.<\/p>\n<h3>When and Why to Format Numbers as Text<\/h3>\n<p>You might wonder why anyone would trade the computational power of numbers for text in Excel. Let&#8217;s shed some light on this: formatting numbers as text is essential when you&#8217;re dealing with data that shouldn&#8217;t be manipulated mathematically, like phone numbers or zip codes. It&#8217;s also vital for preserving leading zeros, which are critical in product codes. Imagine typing a phone number that starts with zero, only to have Excel strip it away \u2014 frustrating, right?<\/p>\n<p>Furthermore, when you want to splice numbers into strings of text \u2014 perhaps for a report or a custom message \u2014 maintaining the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/predetermined-number-formatting\/\" target=\"_blank\" rel=\"noopener\">number\u2019s format<\/a> is key. Take, for example, saying &#8220;Sales last year increased by over 15%&#8221;; you need that <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/percentage-signs-in-excel\/\" target=\"_blank\" rel=\"noopener\">percentage sign<\/a> to stick with the 15, and formatting it as text is the way to go. Additionally, if you intend to use wildcards for lookups or want to ensure that data imports and exports carry over seamlessly without altering the data&#8217;s nature, text formatting becomes your ally.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Simple_Techniques_to_Convert_Numbers_to_Text\"><\/span>Simple Techniques to Convert Numbers to Text<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Adding an Apostrophe: The Quickest Trick<\/h3>\n<p>When you&#8217;re dealing with just a handful of cells and speed is of the essence, adding an apostrophe before the number is the fastest, no-fuss method you can employ. It&#8217;s as simple as double-clicking into a cell and typing an apostrophe before your numeric entry, effectively preserving any leading zeros or specific number sequences as text. A green triangle will then appear in the corner of the cell, indicating that the number is now treated as text.<\/p>\n<p>To add an apostrophe to change a number to text format in Excel, follow these steps:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> Select the Cell:<\/strong> Click on the cell where you want to enter the number as text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A283A10.207725_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-1.png\" alt=\"Format Numbers as Text in Excel\" width=\"428\" height=\"220\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> Add Apostrophe:<\/strong> Type an apostrophe (<code>'<\/code>) before the number (e.g., <code>'1545<\/code>). Press Enter to confirm.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A283A16.904542_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-2.png\" alt=\"Format Numbers as Text in Excel\" width=\"496\" height=\"297\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>RESULT: <\/strong><\/span>Complete the same for the remaining values. The numbers are now stored as text, indicated by the leading apostrophe which will not be displayed in the cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A283A25.048288_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-3.png\" alt=\"Format Numbers as Text in Excel\" width=\"507\" height=\"270\" \/><\/p>\n<p>Do remember, this method is perfect for those times when you&#8217;re in a dash and only need to adjust a cell or two. However, should you require converting numbers to text in bulk, there are more efficient methods at your disposal, designed to tackle data on a larger scale.<\/p>\n<h3>Using the TEXT Function for Detailed Formatting<\/h3>\n<p>Excel&#8217;s <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-text-function\/\" target=\"_blank\" rel=\"noopener\">TEXT function<\/a> comes to the rescue when you wish to sprinkle a dash of specificity in your data formatting endeavors. With this function, you can transform numbers into text while applying the formatting touch you desire. This leverages Excel\u2019s in-depth format options, encapsulating dates, percentages, currencies, and more within a text string.<\/p>\n<p>You&#8217;d typically use the formula: <code>=TEXT(Value you want to format, \"Format code you want to apply\")<\/code>, and Excel does the rest, applying your specified format.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Select the Cell: Click on the cell or range of cells you want to format as text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A323A21.949390_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-4.png\" alt=\"Format Numbers as Text in Excel\" width=\"209\" height=\"200\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> <\/strong>Format Cells Dialog: Right-click the selected cell(s) and choose &#8220;<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-1-format-cells\/\" target=\"_blank\" rel=\"noopener\">Format Cells<\/a>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A343A47.947726_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-5.png\" alt=\"Format Numbers as Text in Excel\" width=\"603\" height=\"784\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>Select Text Format: In the Format Cells dialog box, go to the &#8220;Number&#8221; tab, select &#8220;Text,&#8221; and then click &#8220;OK.&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A353A01.031555_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-6.png\" alt=\"Format Numbers as Text in Excel\" width=\"1003\" height=\"694\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Enter the Number: Type the number in the cell. It will now be treated as text.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A363A09.369760_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-7.png\" alt=\"Format Numbers as Text in Excel\" width=\"210\" height=\"190\" \/><\/p>\n<p>The TEXT function is perfect when you need to display data in a uniform format, or when concatenating numbers with text to make the information more understandable. With the various format codes available, ranging from simple number separators to complex date structures, the opportunities are extensive.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Working_Smarter_with_Excels_Tools\"><\/span>Working Smarter with Excel&#8217;s Tools<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Utilizing &#8216;Text to Columns&#8217; for Bulk Conversions<\/h3>\n<p>If you&#8217;re facing a mountain of numbers that need to be converted to text, roll up your sleeves and bring out Excel&#8217;s &#8216;<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-text-to-columns\/\" target=\"_blank\" rel=\"noopener\">Text to Columns<\/a>&#8216; wizard. It&#8217;s a powerful feature designed for dealing with data en masse, letting you swiftly convert multiple cells without breaking a sweat. Even better, it&#8217;s formula-free, taking you through a series of simple steps to perform the conversion for an <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-apply-formula-to-entire-column\/\" target=\"_blank\" rel=\"noopener\">entire column<\/a> or selection of cells.<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Start by selecting the cells you want to convert.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A483A12.520136_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-8.png\" alt=\"Format Numbers as Text in Excel\" width=\"272\" height=\"246\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span> Navigate to the Data tab, and in there you will find &#8216;Text to Columns&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A473A58.418351_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-9.png\" alt=\"Format Numbers as Text in Excel\" width=\"1349\" height=\"471\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>Select &#8216;Delimited&#8217; even though your data isn&#8217;t so, and click on &#8216;Next&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A483A51.633722_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-10.png\" alt=\"Format Numbers as Text in Excel\" width=\"1258\" height=\"664\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> <\/strong>Then simply uncheck all delimiter options, then click on &#8216;Next&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A493A03.268470_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-11.png\" alt=\"Format Numbers as Text in Excel\" width=\"1271\" height=\"653\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5: <\/strong><\/span>Select the column data format as &#8216;Text&#8217;, then click on &#8216;Finish&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A493A23.729443_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-12.png\" alt=\"Format Numbers as Text in Excel\" width=\"1312\" height=\"680\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">RESULT:<\/span> <\/strong>And voila! Like magic, you&#8217;ve converted those pesky numbers to text in no time.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Format Numbers as Text in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/06\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia650772972024-06-07T183A493A43.957294_Quick_Excel_Tips_Format_Numbers_as_Text_in_Seconds_-13.png\" alt=\"Format Numbers as Text in Excel\" width=\"191\" height=\"165\" \/><\/p>\n<p>It&#8217;s a method favored by many due to its simplicity and rapid execution; especially when compared with other conversion methods, it stands out for its ease and efficiency.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs_All_About_Number-to-Text_Conversion_in_Excel\"><\/span>FAQs: All About Number-to-Text Conversion in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>What is the Excel text function?<\/h3>\n<p>The <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c\" target=\"_blank\" rel=\"nofollow noopener\">Excel TEXT function<\/a> is a game-changer that lets you convert numbers to text with specific formatting. Just type <code>=TEXT(value, \"format_text\")<\/code>, and it will deliver the number as a text string in the format you\u2019ve specified. Whether you need currency, dates, or any other custom number format, the TEXT function has got you covered, ensuring your data looks exactly the way you want it to.<\/p>\n<h3>Can I convert a whole column of numbers to text quickly?<\/h3>\n<p>Absolutely! To convert a whole column of numbers to text swiftly, the &#8216;Text to Columns&#8217; wizard in Excel is the tool to use. It&#8217;s a straightforward process: select your column, head over to the Data tab, pick &#8216;Text to Columns&#8217;, and click through the steps. Choose &#8216;Text&#8217; in the last step, and you&#8217;re done. This will change your entire column to text format in mere moments.<\/p>\n<h3>How do I prevent Excel from automatically formatting numbers as text?<\/h3>\n<p>To stop Excel from auto-formatting numbers as text, first ensure you&#8217;re entering data into cells set to the &#8216;General&#8217; or specific numeric format. Watch out for start-of-cell apostrophes or spaces that trigger text formatting. If you import data, use the &#8216;Text to Columns&#8217; wizard or Paste Special options to control the format upon entry. Double-check import settings, and consider using <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-data-validation\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;s Data Validation<\/a> feature to restrict the data type allowed in each cell.<\/p>\n<h3>How to convert numbers into text in Excel?<\/h3>\n<p>To convert numbers into text, you&#8217;ve got a few tricks up your sleeve in Excel. Use the &#8216;TEXT&#8217; formula for custom text formatting, or add an apostrophe before the number for a quick fix. For larger datasets, the &#8216;Text to Columns&#8217; wizard within the Data tab works wonders, or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/copy-the-cell-above-in-excel\/\" target=\"_blank\" rel=\"noopener\">copy the cells<\/a> and use &#8216;Paste Special&#8217; as &#8216;Values&#8217; with a text format. These methods will keep your numbers looking exactly as you need them\u2014ensuring every digit is treated as text.<\/p>\n<h3>How do you convert to numbers stored as text in Excel?<\/h3>\n<p>To convert a number stored as text back to a number in Excel, you can utilize the &#8216;Convert to Number&#8217; option. Simply select the cells with the text-formatted numbers, look for the warning icon (an exclamation mark in a yellow triangle), and choose &#8216;Convert to Number&#8217; from the dropdown menu. If this isn&#8217;t available, select the cells, go to the &#8216;Home&#8217; tab, find the &#8216;Number&#8217; group, and select &#8216;General&#8217; or &#8216;Number&#8217; from the format options. Your text-formatted numbers will align right, signifying a successful conversion to number format.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transform numbers into text in Excel effortlessly. Explore error checks, TEXT function, quick tricks, and ensure smooth data conversion compatibility.<\/p>\n","protected":false},"author":1,"featured_media":47733,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Format Numbers as Text in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3],"tags":[657,2877,2878],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/47465"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=47465"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/47465\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/47733"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=47465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=47465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=47465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}