How to Use the TEXT Formula to Apply Special Formatting to a Field?

Formatting Numeric Fields with the TEXT() Formula

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

This formula can also be applied to other numeric field formats.

Formatting Date Fields with the TEXT() Formula

To display the full weekday name (e.g., "Friday"), use TEXT(A1,'EE'). To display the abbreviated form (e.g., "Fri"), use TEXT(A1,'E').

For other formatting options, please refer to this document.