Ragic Logo
<< Hiding fields from the left sidebar search toolTable of ContentsGetting string values before and after a specified character in Ragic >>

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
<< Hiding fields from the left sidebar search toolTable of ContentsGetting string values before and after a specified character in Ragic >>
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Keep in touch:
Blog
Email
Facebook
Twitter
Ragic, Inc.
1-888-666-8037
Terms
Privacy