{"id":9947,"date":"2019-03-26T12:28:06","date_gmt":"2019-03-26T11:28:06","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9947"},"modified":"2023-11-30T17:45:15","modified_gmt":"2023-11-30T16:45:15","slug":"value-formula-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/value-formula-in-excel\/","title":{"rendered":"VALUE Formula in Excel"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Converts text into a numeric value<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=VALUE(<span style=\"color: #0000ff\">text<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=VALUE(<span style=\"color: #0000ff\">text to be converted to a numeric value<\/span>)<\/p>\n<hr \/>\n<p>We can easily change text into its corresponding<strong> numeric value<\/strong> using the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extract-cell-value\/\" target=\"_blank\"><strong>VALUE formula\u00a0<\/strong>in Excel<\/a>. It is also interesting as we can try out different types and see how it looks like in its numeric format.<\/p>\n<p>Let us try out a couple of data types: Dates, currency, and time to name a few!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/34g-UVPAf-g?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">VALUE-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>VALUE\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #0000ff\">=VALUE(<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"VALUE Formula in Excel\" class=\"aligncenter size-full wp-image-10092\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-01.jpg\" alt=\"VALUE Formula in Excel\" width=\"425\" height=\"158\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-01.jpg 425w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-01-300x112.jpg 300w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>VALUE\u00a0<\/b>arguments:<\/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\/value-formula-in-excel\/#text\" title=\"text\">text<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"text\"><\/span><span style=\"color: #0000ff\"><em><strong>text<\/strong><\/em><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>What is the text to be converted to a numeric value?<\/strong><\/p>\n<p><em>Select the cell containing the text that you want to convert:<\/em><\/p>\n<h2 style=\"text-align: center\">=VALUE(<span style=\"color: #0000ff\">C9)<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"VALUE Formula in Excel\" class=\"aligncenter size-full wp-image-10093\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-02.jpg\" alt=\"VALUE Formula in Excel\" width=\"428\" height=\"159\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-02.jpg 428w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-02-300x111.jpg 300w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"VALUE Formula in Excel\" class=\"aligncenter size-full wp-image-10094\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-03.jpg\" alt=\"VALUE Formula in Excel\" width=\"448\" height=\"177\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-03.jpg 448w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-03-300x119.jpg 300w\" sizes=\"(max-width: 448px) 100vw, 448px\" \/><\/p>\n<p>You can see that the text are all now in their numeric values!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"VALUE Formula in Excel\" class=\"aligncenter size-full wp-image-10095\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-04.jpg\" alt=\"VALUE Formula in Excel\" width=\"452\" height=\"186\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-04.jpg 452w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/VALUE-FORMULA-04-300x123.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>How to Use the VALUE Formula in Excel<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/ebooks.myexcelonline.com\/products\/101-most-popular-excel-formulas-e-book\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-10741\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book.png\" alt=\"\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; What does it do? Converts text into a numeric value Formula breakdown: =VALUE(text) What it means: =VALUE(text to be converted to a numeric value) We can easily change text into its corresponding numeric value using the VALUE formula\u00a0in Excel. It is also interesting as we can try out different types and see how it [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17696,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"VALUE Formula in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[489,3,14],"tags":[142,70,490],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9947"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=9947"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9947\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17696"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=9947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=9947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=9947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}