Manuals/calci/text
Jump to navigation
Jump to search
T(SomeValue,SomeFormat)
where,
SomeValue - is the numeric value.
SomeFormat - is a numeric format as atext string enclosed in quotation marks.
Calci converts a value to text in a specific number format.
SomeFormat cannnot contain an asterisk(*).
TEXT
T
Lets see an example in (Column2,Row1)
=T(B2)
T returns the text.
Consider another example
=T(9)
T returns ""(empty string).
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | SMITH | 1500 | 4 | 5 |
Row2 | 0 | 8 | 9 | 128 |
Row3 | 12 | 67968 | 14 | 15 |
Row4 | 17 | 18 | 10000 | 20 |
Row5 | 29 | 67994 | 10027 | 168 |
Row6 | 3000 | 0.850904 | 1.619775 | 0.525322 |