[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
    - ASC
    - BAHTTEXT
    - CHAR
    - CLEAN
    - CODE
    - CONCAT
    - CONCATENATE
    - DBCS
    - DOLLAR
    - FIND
    - FINDB
    - FIXED
    - JIS
    - LEFT
    - LEFTB
    - LEN
    - LENB
    - LOWER
    - MID
    - MIDB
    - PROPER
    - REPLACE
    - REPLACEB
    - REPT
    - RIGHT
    - RIGHTB
    - SEARCH
    - SEARCHB
    - SUBSTITUTE
    - T
    - TEXT
    - TEXTAFTER
    - TEXTBEFORE
    - TEXTJOIN
    - TEXTSPLIT
    - TRIM
    - UNICHAR
    - UNICODE
    - UPPER
    - VALUE
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

TEXT

This function formats a number and converts it to text.

Syntax

TEXT(value, text)

Arguments

The text argument requires a string. Value requires numeric data or a reference to a cell that contains numeric data.

Data Types

Returns string data.

Examples

TEXT(A1,"$0.00") gives the result $10.00 if A1 contains 10