This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

 
Home
4D v19
4D View Pro Reference
4D View Pro Formulas
TEXT

TEXT 


 

TEXT ( value , format ) 
Parameter Type   Description
value  Number, CellRef in Numeric value to format to text
format  Text in Format to apply to value

The TEXT function returns a string composed of value number formatted according to format.

Pass a numeric data or a reference to a cell that contains numeric data in value and a text argument in format.

Example  

TEXT(A1,"$0.00") //$10.00 if A1 contains 10

TEXT(100,"0.00€") //100.00€

Previous page
Next page

 
PROPERTIES 

Product: 4D
Theme: 4D View Pro Formulas

 
PAGE CONTENTS 
Description
Example
 
HISTORY 

 
ARTICLE USAGE

4D View Pro Reference ( 4D v19)