VALUE

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.

=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.

FIXED

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

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.

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″.

PROPER

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

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 “ห้าบาทห้าสิบสตางค์”.