--- title: "VALUE function in Excel: syntax and examples | PracticeExcel" description: "How to use VALUE in Excel and Google Sheets: turn numbers stored as text into real numbers, and fix sums that come out as 0." canonical_url: "https://practiceexcelonline.com/functions/value" locale: en meta: "og:description": "How to use VALUE in Excel and Google Sheets: turn numbers stored as text into real numbers, and fix sums that come out as 0." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VkFMVUUgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBWQUxVRSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogdHVybiBudW1iZXJzIHN0b3JlZCBhcyB0ZXh0IGludG8gcmVhbCBudW1iZXJzLCBhbmQgZml4IHN1bXMgdGhhdCBjb21lIG91dCBhcyAwLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_VALUE(text)%2Cp_Ii9mdW5jdGlvbnMvdmFsdWUi%2Cs_v2nQjSm0KO41S8nl.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "VALUE function in Excel: syntax and examples | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VkFMVUUgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBWQUxVRSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogdHVybiBudW1iZXJzIHN0b3JlZCBhcyB0ZXh0IGludG8gcmVhbCBudW1iZXJzLCBhbmQgZml4IHN1bXMgdGhhdCBjb21lIG91dCBhcyAwLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_VALUE(text)%2Cp_Ii9mdW5jdGlvbnMvdmFsdWUi%2Cs_v2nQjSm0KO41S8nl.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **The VALUE function** Converts text that looks like a number, such as "1,250" or "15%", into a real number you can calculate with. = VALUE( ## **Syntax** ``` VALUE(text) ```
**text **
The text to convert, or a cell that holds it. Numbers, percentages, dates and times written as text all work.
## **Examples** C1=VALUE(A2) | | A | B | C | | --- | --- | --- | --- | | 1 | Amount as text | | **1250** | | 2 | 1,250 | | | B1=VALUE("15%") | | A | B | | --- | --- | --- | | 1 | | **0.15** | B1=VALUE(MID("SKU-0042",5,4)) | | A | B | | --- | --- | --- | | 1 | | **42** | ## **Questions**
### Why does VALUE return The text is not a number Excel can read, for example because it holds letters or a stray space, or uses a decimal separator your Excel does not use. Clean it first with TRIM or SUBSTITUTE.
### Is there a quicker way to turn text into numbers? Any math on the text converts it, so =A2\*1 and =--A2 do the same as VALUE. For a whole column, Data > Text to Columns > Finish converts in place.
## **Related functions** - [**TEXT**](https://practiceexcelonline.com/functions/text) - [**ISNUMBER**](https://practiceexcelonline.com/functions/isnumber) - [**MID**](https://practiceexcelonline.com/functions/mid) - [**TRIM**](https://practiceexcelonline.com/functions/trim) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/functions/value#webpage","description":"How to use VALUE in Excel and Google Sheets: turn numbers stored as text into real numbers, and fix sums that come out as 0.","name":"VALUE function in Excel: syntax and examples","url":"https://practiceexcelonline.com/functions/value","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/functions/value#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/functions/value#/schema/question/1"},{"@id":"https://practiceexcelonline.com/functions/value#/schema/question/2"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/functions/value"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/functions/value#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://practiceexcelonline.com/functions","position":2},{"@type":"ListItem","name":"VALUE function in Excel: syntax and examples","position":3}]},{"@id":"https://practiceexcelonline.com/functions/value#article","description":"How to use VALUE in Excel and Google Sheets: turn numbers stored as text into real numbers, and fix sums that come out as 0.","headline":"VALUE function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VkFMVUUgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBWQUxVRSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogdHVybiBudW1iZXJzIHN0b3JlZCBhcyB0ZXh0IGludG8gcmVhbCBudW1iZXJzLCBhbmQgZml4IHN1bXMgdGhhdCBjb21lIG91dCBhcyAwLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_VALUE(text)%2Cp_Ii9mdW5jdGlvbnMvdmFsdWUi%2Cs_v2nQjSm0KO41S8nl.png","@type":["Article","TechArticle"],"author":{"@id":"https://practiceexcelonline.com/#identity"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/functions/value#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/functions/value#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/functions/value#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Why does VALUE return","acceptedAnswer":{"@type":"Answer","text":"The text is not a number Excel can read, for example because it holds letters or a stray space, or uses a decimal separator your Excel does not use. Clean it first with TRIM or SUBSTITUTE."}},{"@id":"https://practiceexcelonline.com/functions/value#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Is there a quicker way to turn text into numbers?","acceptedAnswer":{"@type":"Answer","text":"Any math on the text converts it, so =A2*1 and =--A2 do the same as VALUE. For a whole column, Data > Text to Columns > Finish converts in place."}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VkFMVUUgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBWQUxVRSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogdHVybiBudW1iZXJzIHN0b3JlZCBhcyB0ZXh0IGludG8gcmVhbCBudW1iZXJzLCBhbmQgZml4IHN1bXMgdGhhdCBjb21lIG91dCBhcyAwLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_VALUE(text)%2Cp_Ii9mdW5jdGlvbnMvdmFsdWUi%2Cs_v2nQjSm0KO41S8nl.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VkFMVUUgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBWQUxVRSBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogdHVybiBudW1iZXJzIHN0b3JlZCBhcyB0ZXh0IGludG8gcmVhbCBudW1iZXJzLCBhbmQgZml4IHN1bXMgdGhhdCBjb21lIG91dCBhcyAwLg%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_VALUE(text)%2Cp_Ii9mdW5jdGlvbnMvdmFsdWUi%2Cs_v2nQjSm0KO41S8nl.png"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.