Text()

This function is used to convert a numeric value into text format, which can be specified by the user in the function itself. The value once converted into text format, cannot be used for any mathematical calculations.

Syntax:

= Text (Value, Number Format)

Value = the number (or cell containing numeric value) which is to be converted into text

Number Format = specific text format in which the number should be converted

Example:

For the following examples function statements, let us assume that cell 'A1' contains the number - 25.

- =Text(A1,"0") - The result will be - 25
- =Text(A1,"0.0") - The result will be - 25.0
- =Text(A1,"0.00") - The result will be - 25.00
- =Text(A1,"0%) - The result will be - 2500% {as each unit of 25 is 100%}
- =Text(A1,"0.0%") - The result will be - 2500.0%
- =Text(A1,"$0.0") - The result will be - $25.0

Note: 1) You cannot use any text prefix with this number. For example =Text(A1,"Rs.0.00") will result in error; 2) The above results look numeric - percentages, decimals, etc. but have been converted into text and they cannot be used for any calculations.

## 0 comments:

## Post a Comment