Format numbers as text with TEXT

The TEXT function converts a value into text using a format code that you choose. In this exercise, you are finishing the labels for a monthly KPI summary that will be shared with stakeholders. The report already includes raw dates and numbers, and your job is to turn them into polished text labels that are ready to paste into the final summary.

TEXT has two arguments:

=TEXT(value, format_text)

The first argument is the raw date or number. The second argument is a format code in double quotes that controls how the result should look.

Here are a few format-code building blocks that will help in this exercise:

Code	Meaning	Example result
MMMM	Full month name	January
D	Day number	20
YYYY	Four-digit year	2025
0%	Percentage with no decimal places	85%
$#,##0	Currency with commas and no cents	$50,000
$#,##0.00	Currency with commas and cents	$182,450.75

In this sheet, the label in column A tells you the style each result should have:

• Reporting month and Comparison month should read like a full month name plus a four-digit year.
• Revenue headline should look like currency with commas and cents.
• Operating budget should look like currency with commas but no cents.
• Conversion rate and Goal attainment should look like percentages with no decimal places.
• Prepared on should read like a full written date with the month name, day number, a comma, and four-digit year.

What you need to do:

1. Look at the report labels in column A to see how each raw value should appear in the finished summary.
2. In cell C7, use TEXT to turn the date in B7 into a month-and-year label.
3. Fill cells C7:C13 with TEXT formulas that match each row's reporting format.

When you're done, column C should contain clean, report-ready text versions of the raw values in column B.

Note: If the editor shows a warning like "Number stored as text" in column C, that is fine to ignore here. TEXT intentionally returns text, because the goal is a polished label, not a numeric value.