Number Formats, Format Painter, Format Cells Dialog
Key Takeaways
- Format Painter copies formatting only (not values); single-click paints once, double-click locks painter until you press Esc
- Apply common number formats from Home > Number (Accounting, Percent, Comma, Increase/Decrease Decimal) or the Number Format gallery
- Format Cells (Ctrl+1) exposes the full Number tab categories: Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, and Custom
- Accounting lines up currency symbols and decimals; Currency places the symbol next to the value — MO-210 prompts often specify which one
- #### in a cell usually means the column is too narrow for the formatted number — widen or AutoFit the column rather than deleting the value
Number Formats, Format Painter, Format Cells Dialog
Quick Answer: MO-210 expects you to copy formatting with Format Painter, apply number formats from the Home ribbon, and use the Format Cells dialog (Ctrl+1) when a task needs a specific category, decimal places, date pattern, or custom code.
These skills sit under Format cells and ranges beside merge and styles. Number formats change how values display; they do not permanently alter the underlying stored number unless you convert to text or paste values. Knowing that distinction prevents "fixing" a problem by retyping data.
Format Painter
Format Painter (Home > Clipboard) copies formatting from a source cell or range and applies it elsewhere.
| Action | Behavior |
|---|---|
| Select source → click Format Painter → click or drag destination | Paints once, then turns off |
| Select source → double-click Format Painter → paint multiple ranges | Stays on until you click Format Painter again or press Esc |
| What is copied | Font, fill, borders, alignment, number formats, and similar cell formatting |
| What is not copied | Cell values, formulas, or comments/notes content |
Exam tips for Format Painter
- If the prompt says "apply the same formatting as cell A1 to B2:B20," Format Painter is usually faster than redoing each setting.
- Painter does not replace Paste Special > Formats, which is another valid path after Copy. Either approach is acceptable when the outcome matches.
- Double-click when you must format several noncontiguous areas (title, totals row, and a side panel) without reselecting the source each time.
- After painting, confirm number formats transferred — a currency source should leave currency destinations, not just bold/fill.
Apply Number Formats from the Ribbon
On Home > Number, the most common Associate controls are:
| Control | Typical result |
|---|---|
| Number Format dropdown | General, Number, Currency, Accounting, Short/Long Date, Time, Percentage, Fraction, Scientific, Text, and More Number Formats… |
| Accounting Number Format ($) | Accounting style with currency symbol and aligned decimals |
| Percent Style (%) | Multiplies the displayed value by 100 and adds % (0.15 → 15%) |
| Comma Style | Thousand separators with two decimal places (similar to Accounting without a currency symbol) |
| Increase Decimal / Decrease Decimal | Adds or removes decimal places on the current format |
Percentage caution
If a cell already shows 15 and you click Percent Style, Excel treats 15 as 1500%. Enter 0.15 (or 15%) before or after applying the format carefully. Tasks that say "format as a percentage" usually assume the underlying values are already fractional (0.15) or already entered with %.
Dates and times
Dates are serial numbers formatted to look like dates. Applying Short Date or Long Date from the gallery (or Date category in Format Cells) changes display. If a "date" is left-aligned text, number formats will not convert it until you enter a real date value.
Format Cells Dialog Box
Open Format Cells with Ctrl+1, right-click > Format Cells, or Home > Number dialog launcher / More Number Formats…
Tabs you will use on MO-210:
| Tab | Purpose |
|---|---|
| Number | Category, decimal places, symbol, sample preview |
| Alignment | Horizontal/vertical, wrap, shrink, indent, orientation, merge |
| Font | Typeface, size, color, underline, effects |
| Border | Line style and presets |
| Fill | Background color/pattern |
| Protection | Locked/Hidden (relevant when sheet protection is on) |
Number tab categories to know
| Category | Use when the prompt asks for |
|---|---|
| General | Default; Excel decides based on entry |
| Number | Decimals, thousand separator, negative number styles |
| Currency | Symbol immediately beside the value; choose symbol and decimals |
| Accounting | Currency symbol at the cell edge, decimals aligned in the column |
| Date / Time | Specific display patterns (for example, 14-Mar-2026) |
| Percentage | Percent display with set decimal places |
| Fraction | Display as fractions |
| Scientific | Scientific notation |
| Text | Treat cell contents as text (handy for leading zeros such as ZIP codes when Special is not used) |
| Special | Zip Code, Phone Number, Social Security Number (locale-dependent) |
| Custom | Type a format code when built-in categories are not enough |
Currency vs Accounting (frequent trap)
Both show money, but layout differs:
- Currency:
$1,234.50with the dollar sign adjacent to the digits. - Accounting:
$aligned left in the cell and1,234.50aligned so decimals line up down the column; zeros may display as a dash depending on settings.
If the prompt says Accounting format, use Accounting Number Format or Format Cells > Accounting — not the Currency category. Graders compare the applied format, not approximate appearance.
Custom formats (awareness level)
Associate tasks may open Custom for a simple code (for example, showing a trailing unit or a specific date pattern). You do not need advanced custom-format mastery, but you should know Custom lives on the Number tab and that the Sample box previews the active cell.
When You See
A cell filled with #### usually means the column is too narrow to display the formatted number or date — not that the value was deleted. Fix it by:
- Double-clicking the column's right boundary (AutoFit Column Width), or
- Dragging the column wider, or
- Home > Format > Column Width / AutoFit Column Width.
Do not clear the cell. Applying a shorter format (fewer decimals) can also help, but AutoFit is the first response on most exam tasks.
Combining Format Painter with Number Formats
Efficient project workflow:
- Format one model cell completely in Format Cells (Accounting, 2 decimals, bold, border).
- Use Format Painter (or Paste Special > Formats) to spread that look to the rest of the money column.
- Use Increase/Decrease Decimal only if a subset needs a different precision.
This beats manually opening Format Cells on every range and reduces missed settings under time pressure.
Exam Scenario Walkthrough
Prompt: Format D2:D50 as Accounting with the $ symbol and two decimal places. Format E2:E50 as a percentage with one decimal place. Copy the formatting from A1 to A2:A10 with Format Painter. Open Format Cells and apply the Special Zip Code format to column H. AutoFit any column that shows ####.
- Select D2:D50 → Home > Accounting Number Format (confirm two decimals; adjust with Increase/Decrease Decimal if needed).
- Select E2:E50 → ensure values are fractional → Percent Style → Decrease/Increase Decimal to one place.
- Select A1 → Format Painter → drag A2:A10.
- Select column H → Ctrl+1 → Number > Special > Zip Code → OK.
- AutoFit any #### columns.
That sequence demonstrates Format Painter, ribbon number formats, and Format Cells dialog formatting — the second cluster of Domain 2 cell-formatting objectives.
How do you keep Format Painter active so you can apply the same source formatting to several separate ranges?
A task requires money values with the currency symbol at the left edge of the cell and decimals aligned down the column. Which format matches?
Cell C5 shows #### after you apply a date format. What should you try first?
Which keyboard shortcut opens the Format Cells dialog box?