VALUE

Convert a text string without number format in Excel
Converts a text argument to a number

Rational

Convert a text string without number format.

Description

The Excel VALUE function convert valid numbers with various number formatting (number, date, currency etc.) into a code number. For example, “=VALUE(“31-12-2017”)” returns “43100”, a number code that is stored in excel at its backend.

Syntax

=VALUE (text)

Parameters

text – The text to convert in value

Return Value

The numerical value of the text.

Key Notes

  • The VALUE function converts text that appears in an Excel’s valid format (i.e. a number, date, or time format) into a numeric value.
  • Use the TEXT function to translate a number into a specific text format.
  • It returns #VALUE! error in case the text contains non – numerical character or not in one of the recognized Excel formats.
  • You do not generally need to use the VALUE function in a formula because Excel automatically converts text to numbers as necessary. This function is provided for compatibility with other spreadsheet programs.” as stated by Support.Office.

Keep Reading Similar Functions:

Capitalizes the first letter of each word in Excel

PROPER

The PROPER function capitalizes the first letter of each word in a given alphabetical text. I.e., =PROPER(“michael jackson”) returns “Michael Jackson”.

Read More »
Convert number to currency (Dollar) in Excel

DOLLAR

The DOLLAR function display a number with a dollar currency. I.e. =DOLLAR(500) returns $500 as a currency but in a text format.

Read More »
Change the format of a number and converts it to text in Excel

TEXT

The TEXT function allows converting a value to a specific format based on the given format codes. E.g. =TEXT(31-12-2018,”MM/DD/YYYY”) return ” 12/31/2018″.

Read More »
Round a number to decimal places with or without commas in Excel

FIXED

The FIXED function displays a number in a text format after rounding the specified number of decimal places with or without commas.

Read More »
Converts number Thai currency Excel

BAHTTEXT

The Excel BAHTTEXT function converts a number to Thai currency with a suffix of “Baht”. I.e., to translate $5.50 in cell B7 =BAHTTEXT(B7) returns “ห้าบาทห้าสิบสตางค์”.

Read More »