Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 »
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 »
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 »
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 »