Number Formats, Format Painter, Format Cells Dialog

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.

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:

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:

Number tab categories to know

Currency vs Accounting (frequent trap)

Both show money, but layout differs:

• Currency: $1,234.50 with the dollar sign adjacent to the digits.
• Accounting: $ aligned left in the cell and 1,234.50 aligned 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:

1. Double-clicking the column's right boundary (AutoFit Column Width), or
2. Dragging the column wider, or
3. 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:

1. Format one model cell completely in Format Cells (Accounting, 2 decimals, bold, border).
2. Use Format Painter (or Paste Special > Formats) to spread that look to the rest of the money column.
3. 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 ####.

1. Select D2:D50 → Home > Accounting Number Format (confirm two decimals; adjust with Increase/Decrease Decimal if needed).
2. Select E2:E50 → ensure values are fractional → Percent Style → Decrease/Increase Decimal to one place.
3. Select A1 → Format Painter → drag A2:A10.
4. Select column H → Ctrl+1 → Number > Special > Zip Code → OK.
5. 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.