4D Online Documentation Center

4D v18

TEXT

4D View Pro Handbuch
- Formeln in 4D View Pro
- - Operatoren und Werte
  - Zellenreferenzen
  - Formeln vom Plug-In 4D View konvertieren
  - ABS
  - ACOS
  - AND
  - ASIN
  - ATAN
  - AVERAGE
  - COLUMNLETTER
  - COS
  - COUNTA
  - EXP
  - FALSE
  - FINDCELL
  - FV
  - IF
  - INDIRECT
  - ISBLANK
  - LEN
  - LN
  - LOOKUP
  - MAX
  - MID
  - MIN
  - NOT
  - NOW
  - NPER
  - OR
  - PI
  - PMT
  - PV
  - RAND
  - RATE
  - ROUND
  - ROW
  - RUNTIME_CURRENT_TIME
  - RUNTIME_DATE
  - RUNTIME_STRING
  - RUNTIME_TIME
  - RUNTIME_VIEW_STRING
  - SIN
  - SQRT
  - STDEV.P
  - SUBSTITUTE
  - SUM
  - TAN
  - TEXT
  - TODAY
  - TRUE
  - TYPE
  - VAR.P

Home

4D v18

4D View Pro Handbuch

Formeln in 4D View Pro

TEXT

TEXT


	TEXT ( value , format )

	Parameter		Typ				Beschreibung
	value		Zahl, CellRef				Numeric value to format to text
	format		Text				Format to apply to value

Beschreibung

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.

Beispiel

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

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

Vorige Seite

EIGENSCHAFTEN

Produkt: 4D
Thema: Formeln in 4D View Pro

GESCHICHTE

ARTIKELVERWENDUNG

4D View Pro Handbuch ( 4D v18)

© 1985-2020 4D SAS / 4D, Inc. Alle Rechte vorbehalten.

Fehler melden