> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Text format conversion

> Convert text formats in DingTalk Spreadsheet with the TEXT and T functions.

| Tag | Conversion,<br />TEXT, T |
| --- | ------------------------ |

## Text, Date => Numerical: the VALUE function, or mathematical operators

The VALUE function attempts to convert various arguments into numerical values. If the conversion fails, it returns the #VALUE! error.

The same effect can be achieved through type conversion via mathematical operations. During multiplication, the operands are first converted to numerical type.

Operators such as "--A2" and "A2/1" can also achieve the same effect.

## Numerical, Date => Text: the TEXT function, or the concatenation operator "&"

The TEXT function applies a specified format (the second argument) to various types of data (the first argument) and returns a text result. When the specified format is "0", the data is converted to its most basic text form.

Similarly, the text concatenation operator "&" first attempts to convert its operands to text during the operation, so it can also be used to convert values to text.

## Conversion to date and time

In DingTalk Spreadsheet, dates are stored as numerical values. The numerical value combined with a "format" produces a date and time. Therefore, to convert other types of data to a date, you must first convert the data to a numerical value.

After obtaining the numerical result, go to **Toolbar menu > Format > Data format > Date and time** to display the cell as date and time.

***