Function Text()

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.
Share on Google Plus

About Nifty Guru

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Tuesday, May 26, 2009

Function Text()

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.

Function Text()SocialTwist Tell-a-Friend

0 comments:

Post a Comment