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

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

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

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

### FIXED

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

### PROPER

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