Manuals/calci/text

From ZCubes Wiki
Revision as of 21:46, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''T'''(SomeValue,SomeFormat) where, '''SomeValue''' - is the numeric value. '''SomeFormat''' - is a numeric...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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