Members lesson 29
TEXT for display
Format currency, percentages, and dates as text for labels and reports.
What you will practice
- Display currency and percentages with TEXT
- Format dates for reports
- Combine formatted values with labels
Lesson preview
Starting tableDisplay labels
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Source value | Display task | Text result | |
| 2 | 1,234.50 | Currency | ||
| 3 | 0.26 | Percent | ||
| 4 | 45,351.00 | ISO date | ||
| 5 | Named date | |||
| 6 | Revenue label |