FUNCTION CATALOGUE / TEXT
TEXT Excel function
Formats a value as text.
Correct sentence to use
Format [value] using [format].
Modify this query in PlainFormula →Example formula
=TEXT(A2,"£#,##0.00")
Formats a number and returns text.
Syntax
TEXT(value, format_text)
Argument signature: value, format_text
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.