Parameter List
Syntax
TEXT(number, format)
number
The number, date or time to be converted.
format
The pattern according to which to convert the number, enclosed in quotation marks. Examples: “$0.00”,“#.#%”,“d”,“dd”,“M”,“MM”,“MMM”,“MMMM”,“yy”,“yyyy”,“HH”,“hh”,“ss”,“AM/PM”