Welcome to Portal
Converts a number into text according to a given format.
Syntax
number: The number you want to convert into text. E.g. "21:00"
Examples
Formula |
Result |
=TEXT("21:00";"h AM/PM") |
9 PM |
=TEXT(12.125;"#.##") |
12.12 |
=TEXT("1/2/2020";"dd/mm/yyyy") |
02/01/2020 |
=TEXT(3.12;"# ?/?") |
3 1/8 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Subscribe to receive notifications from this article.