Knowledge Base
How can we help?
Full Site Search

Usage of the TEXT() formula

The text formula 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
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com