Difference between revisions of "Manuals/calci/text"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 16: | Line 16: | ||
*<math>SomeValue</math> is a numeric value to be converted. | *<math>SomeValue</math> is a numeric value to be converted. | ||
*<math>SomeFormat</math> can be a date format, currency format, percentage format etc. | *<math>SomeFormat</math> can be a date format, currency format, percentage format etc. | ||
| − | * | + | *For invalid arguments, Calci displays #N/A error message. |
== Examples == | == Examples == | ||
| Line 42: | Line 42: | ||
=TEXT(A1,"$0,000.00") : Displays '''$5,678.89''' as the output. | =TEXT(A1,"$0,000.00") : Displays '''$5,678.89''' as the output. | ||
| − | =TEXT(A1,"0,000.00") : Displays'''5,678.9''' as the output. | + | =TEXT(A1,"0,000.00") : Displays '''5,678.9''' as the output. |
| − | =TEXT(A2,"0") : Displays'''45,000''' as the output. | + | =TEXT(A2,"0") : Displays '''45,000''' as the output. |
== See Also == | == See Also == | ||
Latest revision as of 14:47, 2 April 2014
TEXT(SomeValue, SomeFormat)
where,
- is a numeric value, and
- is a numeric format in which text is to be displayed.
is a numeric value, and
is a numeric format in which text is to be displayed.TEXT() converts a numeric value to a text in a specified format.
Description
TEXT(SomeValue, SomeFormat)
e.g. TEXT(54,"$00.00") returns 54.00 as a result.
- TEXT function is used to convert a numeric value to a formatted text. Result can no longer be calculated as a number.
- is a numeric value to be converted.
- can be a date format, currency format, percentage format etc.
- For invalid arguments, Calci displays #N/A error message.
Examples
Consider the following examples that demonstrate the use of TEXT() function:
| 5678.89 | ||
| 45000 | ||
=TEXT(A1,"$0,000.00") : Displays $5,678.89 as the output. =TEXT(A1,"0,000.00") : Displays 5,678.9 as the output. =TEXT(A2,"0") : Displays 45,000 as the output.