{"id":3776,"date":"2023-02-02T17:37:58","date_gmt":"2023-02-02T17:37:58","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=3776"},"modified":"2024-04-21T18:09:24","modified_gmt":"2024-04-21T18:09:24","slug":"how-to-convert-formulas-to-values-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-convert-formulas-to-values-in-excel\/","title":{"rendered":"How to Convert Formulas to Values in Excel? 4 Easy Methods."},"content":{"rendered":"<p>Convert Formulas to Values in Excel to solidify your data and prevent any unintended alterations, especially when sharing your spreadsheets with others or finalizing reports. This essential skill is invaluable for financial analysts, project managers, and anyone who needs to preserve the integrity of their data calculations. Whether you&#8217;re preparing a budget, finalizing a project plan, or compiling analytical reports, this guide will walk you through the process of converting formulas to static values in Excel. By mastering this technique, you&#8217;ll ensure your data remains accurate and consistent, making your spreadsheets more reliable and user-friendly for all stakeholders.<\/p>\n<p><strong>\u00a0<\/strong><strong>This Content Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#why-should-we-convert-formulas-to-values?\"><strong> Why Should We Convert Formulas to Values?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-convert-formulas-to-values?\"><strong> How to Convert Formulas to Values?<\/strong><\/a>\n<ul>\n<li><strong>Using a Keyboard Shortcut<\/strong><\/li>\n<li><strong>Using Mouse Trick<\/strong><\/li>\n<li><strong>Using Paste as Values Option from Right Click<\/strong><\/li>\n<li><strong>With a VBA Code<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-convert-to-values-inside-the-formula?\"><strong> How to Convert to Values Inside the Formula?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-get-formula\u2019s-result-value-with-power-query?\"><strong> How to get Formula\u2019s Result Value with Power Query?<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"why-should-we-convert-formulas-to-values?\">1. Why Should We Convert Formulas to Values?<\/strong><\/h2>\n<ul>\n<li>It is preferable to turn all the formulae into static values (paste values) if you provide a report to someone without its source data.<\/li>\n<li>This will prevent anyone from making any changes to the final calculation in a workbook.<\/li>\n<li>Some functions and values will recalculate when you update the worksheet. So, it is better to convert the formulas into values.<\/li>\n<li>If someone wants to use the values from your worksheet, they can easily do that. But if the values have a formula wrapped, copy and paste them becomes much more complex.<\/li>\n<\/ul>\n<h2><strong id=\"how-to-convert-formulas-to-values?\">\u00a02. How to Convert Formulas to Values in Excel Using Multiple Options?<\/strong><\/h2>\n<p>This datasheet contains data or values that were produced using a formula for column <strong>D (Profit).<\/strong> We now want to convert formulas to values. We can remove the formulae by converting these formulas into values using a few simple techniques.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-3777\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-1.png\" alt=\"Convert formulas to values\" width=\"647\" height=\"301\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-1.png 647w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-1-300x140.png 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/p>\n<h3><strong>2.1 Excel Shortcuts in Keyboard by using Paste Special<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Select the range that contains formulas and copy them using <strong>CTRL + C.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-3778\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-2.png\" alt=\"Convert formulas to values\" width=\"640\" height=\"312\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-2.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-2-300x146.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Press <strong>ALT+E+S+V<\/strong> to enable the <strong>Paste special<\/strong> dialogue box. You can also open this dialogue box by clicking the right button of your mouse and selecting <strong>Paste Special. <\/strong>From this dialogue box select <strong>Values<\/strong> and click <strong>OK.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-3779\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-3.png\" alt=\"Convert formulas to values\" width=\"649\" height=\"277\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-3.png 649w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-3-300x128.png 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/p>\n<p><strong>Step 3: <\/strong>All the formulas are now converted or changed into values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3780\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-4.png\" alt=\"Convert formulas to values\" width=\"651\" height=\"300\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-4.png 651w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-4-300x138.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/p>\n<h3><strong>2.2 Using Mouse Trick to Replace a Formula to Value<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Select and copy the range by <strong>CTRL+C<\/strong> command and take your mouse cursor at the right edge of this selection. You will see an icon pointing toward all four directions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3781\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-5.png\" alt=\"Convert formulas to values\" width=\"614\" height=\"275\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-5.png 614w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-5-300x134.png 300w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Click and hold the right button of your mouse and drag the selection towards right and bring it back to its original position.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3782\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-6.png\" alt=\"Convert formulas to values\" width=\"609\" height=\"245\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-6.png 609w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-6-300x121.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<p><strong>Step3: <\/strong>When you bring it back to its original position and leave the right button, an option menu will come up on your screen. Select <strong>Copy Here as Values Only.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3783\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-7.png\" alt=\"Convert formulas to values\" width=\"651\" height=\"321\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-7.png 651w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-7-300x148.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/p>\n<p><strong>Step 4: <\/strong>All the Excel formulas are converted into values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3784\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-8.png\" alt=\"Convert formulas to values\" width=\"655\" height=\"306\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-8.png 655w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-8-300x140.png 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" \/><\/p>\n<h3><strong>2.3 Using Paste as Values Option from Right Click<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Select the range and copy using <strong>CTRL+C<\/strong>. Right click on your mouse. Select <strong>Values (V) <\/strong>under <strong>Paste Options.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3785\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-9.png\" alt=\"Convert formulas to values\" width=\"642\" height=\"234\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-9.png 642w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-9-300x109.png 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/p>\n<p><strong>Step 2:<\/strong> The formulas are changed into values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3786\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-10.png\" alt=\"Convert formulas to values\" width=\"641\" height=\"300\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-10.png 641w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-10-300x140.png 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<h3><strong>2.4 With a VBA Code to Replace Formulas with Values<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Right-click on your worksheet and select <strong>View Code.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3787\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-11.png\" alt=\"Convert formulas to values\" width=\"397\" height=\"312\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-11.png 397w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-11-300x236.png 300w\" sizes=\"(max-width: 397px) 100vw, 397px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Paste this <strong>VBA Code<\/strong> inside the <strong>VBA Module<\/strong> and click on <strong>RUN.<\/strong><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\"><strong>Sub ConvertToValues()<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\"><strong>\u00a0\u00a0\u00a0 With ActiveSheet.UsedRange<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\"><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 .Value = .Value<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\"><strong>\u00a0\u00a0\u00a0 End With<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\"><strong>\u00a0\u00a0\u00a0 MsgBox (&#8220;All Formulas are converted to values&#8221;)<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0000ff;\"><strong>End Sub<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3788\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-12.png\" alt=\"Convert formulas to values\" width=\"578\" height=\"311\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-12.png 578w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-12-300x161.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/p>\n<p><strong>Step 3: <\/strong>This dialogue box will pop up saying <strong>\u201cAll Formulas are converted to values<\/strong>\u201d, click <strong>OK <\/strong>and the formulas in that worksheet will convert into values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3789\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-13.png\" alt=\"Convert formulas to values\" width=\"560\" height=\"333\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-13.png 560w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-13-300x178.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/p>\n<h2><strong id=\"how-to-convert-to-values-inside-the-formula?\">3. How to Convert to Values Inside the Formula?<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Select cell D2 and click <strong>F2<\/strong> button from your keyboard to enable the edit mode.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3790\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-14.png\" alt=\"Convert formulas to values\" width=\"645\" height=\"301\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-14.png 645w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-14-300x140.png 300w\" sizes=\"(max-width: 645px) 100vw, 645px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Select the portion of the formula that you want to change into value and click\u00a0<strong>F9<\/strong> key. You can do this change in the formula bar also.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3791\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-15.png\" alt=\"Convert formulas to values\" width=\"653\" height=\"309\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-15.png 653w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-15-300x142.png 300w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Once you press <strong>F9 <\/strong>key then click on <strong>ENTER <\/strong>button the formula will convert into value. Now do this for each of the cells containing formulas separately.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3792\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-16.png\" alt=\"Convert formulas to values\" width=\"650\" height=\"299\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-16.png 650w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-16-300x138.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<h2><strong id=\"how-to-get-formula\u2019s-result-value-with-power-query?\">4. Converting Formulas to Values using Power Query?<\/strong><\/h2>\n<p><strong>Step 1:<\/strong> Select any cell from the table and go to <strong>Data&gt;&gt;From Table.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3793\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-17.png\" alt=\"Convert formulas to values\" width=\"599\" height=\"442\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-17.png 599w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-17-300x221.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Select <strong>Close &amp; Load<\/strong> from <strong>Power Query Editor.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3794\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-18.png\" alt=\"Convert formulas to values\" width=\"649\" height=\"309\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-18.png 649w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-18-300x143.png 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/p>\n<p><strong>Step 3:<\/strong> This will open a new worksheet for you with the same table but the formulas from column D will be converted into Values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3795\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-19.png\" alt=\"Convert formulas to values\" width=\"633\" height=\"310\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-19.png 633w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/01\/Convert-formulas-to-values-19-300x147.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/p>\n<p><strong>Application of Converting Formulas to Values in Excel:<\/strong><\/p>\n<ul>\n<li><strong>Data Sharing<\/strong>: Convert formulas to calculated values to prevent recipients from altering calculations or seeing proprietary formulas when sharing Excel files.<\/li>\n<li><strong>Report Finalization<\/strong>: Ensure that the values in reports remain static and unaffected by any future changes in the source data or formulas.<\/li>\n<li><strong>Performance Improvement<\/strong>: Enhance spreadsheet performance by converting complex formulas to values, reducing the processing load, especially in large files.<\/li>\n<li><strong>Preventing Errors<\/strong>: Minimize the risk of errors in data by converting formulas to values, safeguarding against accidental deletions or modifications of critical formulas.<\/li>\n<li><strong>Archiving Data<\/strong>: Preserve the state of your data at a specific point in time by converting formulas to values, creating an accurate historical record.<\/li>\n<li><strong>Simplifying Templates<\/strong>: Simplify templates for users who may not be familiar with Excel functions by providing them with straightforward values instead of complex formulas.<\/li>\n<\/ul>\n<p><strong>For ready-to-use Dashboard Templates:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Convert Formulas to Values in Excel to solidify your data and prevent any unintended alterations, especially when sharing your spreadsheets with others or finalizing reports. This essential skill is invaluable for financial analysts, project managers, and anyone who needs to preserve the integrity of their data calculations. Whether you&#8217;re preparing a budget, finalizing a project &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-convert-formulas-to-values-in-excel\/\"> <span class=\"screen-reader-text\">How to Convert Formulas to Values in Excel? 4 Easy Methods.<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[459],"tags":[461,460],"class_list":["post-3776","post","type-post","status-publish","format-standard","hentry","category-convert-formulas-to-values","tag-convert-formulas-to-values","tag-convert-formulas-to-values-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=3776"}],"version-history":[{"count":7,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3776\/revisions"}],"predecessor-version":[{"id":9087,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/3776\/revisions\/9087"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=3776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=3776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=3776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}