Usage of the TEXT() formula

The text formula is used for combining a number or date value into a specified format.

Formatting a number with the TEXT() formula

For the format 12,345.67 you can use TEXT(A1,'#,###.##')

Other number formats can also be used.

Formatting a date field with the TEXT() formula

To format a date field into the name of the weekday like "Friday", you can use TEXT(A1,'EE')

To format a date field into the abbreviated name of the weekday like "Fri", you can use TEXT(A1,'E')

You can refer to other custom date formatting types here.