Date & Time Function: TEXT()

This formula converts a value to a specified format of text.

TEXT(value,format_text)

Value can be a numeric value, a formula or a reference to a cell containing a numeric value.

Format_text is the type of formats applied to the specific number or cell. Some format examples are $0.00, 0%, hh:mm:ss, etc.

Let say you put in function: TEXT($120,"$0.00"), the outcome will be $120.00. The difference is you have specify the decimals by formatting the figure "$120", this could be reference to a cell too.

Keyword: Time, Date