Text and number formatting shortcuts

The Text and number formatting shortcuts mistake to catch

Formatting 0.25 as a percentage shows 25%; multiplying it by 100 as well produces 2500%.

Text and number formatting shortcuts: what Excel is actually doing

Number formats change presentation without changing stored values. Shortcuts can apply currency, percentage, date, time, and general formats quickly.

Read this Text and number formatting shortcuts example

Start with the business need: Standardise headings, dates, percentages, and currency. Read each argument, reference, field, or control in the example before copying it into a larger model.

Ctrl + 1 · Ctrl + B

Evidence that your Text and number formatting shortcuts result is trustworthy

Save a checkpoint before high-impact edits and verify that formulas, names, and print areas still point to the intended ranges.

• Explain how the result supports this task: Standardise headings, dates, percentages, and currency.
• Retain one known-result check and one boundary or exception check.
• Record the source, period, unit, and refresh assumption beside the output.