Excel: NUMBERVALUE & FIXEDVALUE Functions

NUMBERVALUE 

This function in Excel converts a number in text format to numeric value, using specified decimal and group separators. This function can be used to convert locale-specific values into locale-independent values. To perform a numeric conversion, the NUMBERVALUE function uses the custom separators you provide. The decimal_separator is the character used to separate integers from fractional values in the source text. The group_separator is the character used to group text by thousands in the source text. Both separators should be enclosed in double quotes (""). When decimal_separator and group_separator, Excel uses separators for the current locale.

Arguments of NUMBERVALUE Function:

• text - The text to convert to a number.
• decimal_separator - [optional] The character for decimal values.
• group_separator - [optional] The character for grouping by thousands.

FIXED

FIXED function in excel converts a number to text with fixed number of decimals, rounding as needed with the given number of decimals. The FIXED function can be useful when concatenating a formatted number text. The main difference between applying a number format and using FIXED is that the FIXED function converts the number to text, whereas a number format just changes the way a number is displayed. The FIXED function takes three arguments, number, decimals, and no_commas. Number is the number to convert. Decimals is the number of digits to which number will be rounded on the right of the decimal point. If decimals is negative, number will be rounded to the left of the decimal point. Decimals is optional and defaults to 2. 

Arguments of FIXED Function:

• number - The number to round and format.
• decimals - [optional] Number of decimals to use. Default is 2.
• no_commas - [optional] Suppress commas. TRUE = no commas, FALSE = commas. Default is FALSE.