| Tag | Conversion, 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.Back to Spreadsheet