ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel VALUE Function

Excel VALUE Function

How to Use the Excel VALUE Function
Table of contents :
  • What is the Excel VALUE Function?
  • VALUE Syntax
  • How to Use VALUE Function in Excel
  • VALUE Example

Excel VALUE Function

What is the Excel VALUE Function?

The Excel VALUE function converts text that appears in a recognize format (it could be a number, date or time, according to the current regional setting format) to a number.

VALUE Syntax

VALUE(text)

text, text value to convert to a number.

How to Use VALUE Function in Excel

For example, there is data as shown below. Column A contains several texts, appear as numbers, dates and even hours. What is the result of the VALUE function in column B?

Excel VALUE Function

VALUE Function #1

=VALUE(A2)

Nothing special, cell A2 contains alphanumeric without any sign.

The result is 1234.

VALUE Function #2

=VALUE(A3)

Cell A3 contains numbers with thousands separators and decimal separators that correspond to the current regional setting (United State Format).

The result is 1234.45.

VALUE Function #3

=VALUE(A4)

The result is a #VALUE! error. Why? Thousands separators with a period may be used in several countries, but the current regional setting is a united state format, the thousands separator is a comma, applies to decimal separators too.

Use Excel NUMBERVALUE function to convert text with thousands separators or decimal separators that do not match the current regional setting.

VALUE Function #4

=VALUE(A5)

In addition to the thousands separator and decimal separator that must match. If the currency symbol matches the current regional setting, the VALUE function returns no error.

The result is 123.25

VALUE Function #5

=VALUE(A5)

Not only converts text that appears as a number. The VALUE function able to convert text that appears as a time.

The result is 0.5

VALUE Function #6

=VALUE(A6)

The VALUE function able to convert text that appears as a date, with one condition, the text format is by the current regional setting.

The result is 36526

Why the conversion result for text that appears as date and time is a number?

Excel stores data date and time in the form of numbers. For a more detailed explanation, read the following article:

  • How does Excel Stores Dates and Times?

VALUE Function #7

=VALUE(A6)

The result is a #VALUE! Error because the dd/mm/yyyy format is unrecognized in United States format.

Please see the image below for the complete result of VALUE function in column B.

Excel VALUE Function

VALUE Example

Another article using or explain about VALUE Function
  • Add and Remove Leading Zeros in Excel

Another Text Function

Another article about Text Function
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
Usefull links
  • Microsoft VALUE function documentation
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Excel REPLACE Function
What is the Excel REPLACE Function? The excel REPLACE function …

Excel REPLACE Function

Excel DATEVALUE Function
What is the Excel DATEVALUE Function? The DATEVALUE function converts …

Excel DATEVALUE Function

Excel CHOOSE Function
What is the Excel CHOOSE Function? The excel CHOOSE function …

Excel CHOOSE Function

Excel Month Function
What is the Excel MONTH Function? The Excel MONTH function …

Excel MONTH Function

Excel TIMEVALUE Function
What is the Excel TIMEVALUE Function? The Excel TIMEVALUE function …

Excel TIMEVALUE Function

Tags:Excel Function VALUE Function VALUE How to Use VALUE Function in Excel Text Functions

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh