1. Spreadsheet.com Support
  2. Functions
  3. Text functions

TEXT

Converts a number to formatted text.

Sample Usage

TEXT(16)
TEXT(C5)

Syntax

TEXT(value, format)

  • value  - The number, date, or time to format
  • format - The pattern by which to format the number

 

Examples

TEXT(16) returns the Roman number corresponding to the given number, i.e. XVI. 
TEXT(C5) returns the Roman number corresponding to the number in cell C5.