[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer VSCode Plugin
Tutorials
SpreadJS Designer Component
SpreadJS Collaboration Server
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
    - ARRAYTOTEXT
    - 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
    - SJS.ENDWITH
    - SJS.STARTWITH
    - SUBSTITUTE
    - T
    - TEXT
    - TEXTAFTER
    - TEXTBEFORE
    - TEXTJOIN
    - TEXTSPLIT
    - TRIM
    - UNICHAR
    - UNICODE
    - UPPER
    - VALUE
    - VALUETOTEXT
  - Web Functions
  - RegEx Functions
  - Other Functions
Import and Export Reference
Events
API Documentation
Release Notes

VALUETOTEXT

This function converts a value to text.

Syntax

VALUETOTEXT(value, [format])

Arguments

Argument

Description

value

The value to convert.

format

Optional. Specifies the output format.

0 — Concise format (default).

1 — Strict format.

Return Value

Returns a text representation of the specified value.

Remarks

If omitted, format defaults to 0.
Output is always based on General format, regardless of the cell’s NumberFormat.
Empty values return an empty string.
In strict mode:
- Text values are enclosed in double quotes.
- Internal double quotes are escaped as "".
- Boolean and numeric values are not quoted.
- Most error values are not quoted. Dynamic array errors such as #SPILL! and #CALC! are enclosed in double quotes.
Date and time values are returned as their underlying serial numbers.
Function, lambda, rich values, and custom objects return their display representation.
Localized text depends on the current culture settings.

Examples

Formula	Result
`=VALUETOTEXT(1234)`	1234
`=VALUETOTEXT("Hello",1)`	"Hello"
`=VALUETOTEXT(A1)` (A1=2025/1/1)	45658
`=VALUETOTEXT(#SPILL!,1)`	"#SPILL!"

See also