About This Document
The Gnumeric Manual, version 1.12
- Welcome!
- How to Use This Manual
- A Quick Introduction
- Gnumeric Elements
- Working with Data
- Advanced Analysis
- The Solver
- Statistical Analysis
- Graphics: Images, Widgets, and Drawings
- Graphs
- Using Worksheets
- Workbook Settings
- Configuring Gnumeric
- Working with Files
- Printing
- Getting More Help
- Reporting a Problem
- Extending Gnumeric
- Function Reference
  - Bitwise Operations
  - Complex
  - Database
  - Date/Time
  - Engineering
  - Erlang
  - Finance
  - Gnumeric
  - Information
  - Logic
  - Lookup
  - Mathematics
  - Number Theory
  - Random Numbers
  - Statistics
  - String
    
    ASC
    
    CHAR
    
    CLEAN
    
    CODE
    
    CONCATENATE
    
    DOLLAR
    
    EXACT
    
    FIND
    
    FINDB
    
    FIXED
    
    JIS
    
    LEFT
    
    LEFTB
    
    LEN
    
    LENB
    
    LOWER
    
    MID
    
    MIDB
    
    NUMBERVALUE
    
    PROPER
    
    REPLACE
    
    REPLACEB
    
    REPT
    
    RIGHT
    
    RIGHTB
    
    SEARCH
    
    SEARCHB
    
    SUBSTITUTE
    
    T
    
    TEXT
    
    TRIM
    
    UNICHAR
    
    UNICODE
    
    UPPER
    
    VALUE
  - Time Series Analysis
- Keybinding Reference

TEXT

The Gnumeric Manual, version 1.12
Function Reference
String

TEXT — value as a string formatted as format

Synopsis
Arguments
Microsoft Excel Compatibility
See also

Synopsis

TEXT(value,format)

Arguments

value: value to be formatted

format: desired format

Microsoft Excel Compatibility

This function is Excel compatible.

See also

DOLLAR, FIXED, VALUE.