FAQ
How can we help?
Full Site Search

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.

Top of Page

    Start Ragic for Free

    Sign up with Google