Google Sheets web app (rolling service) · Workbook essentials · Beginner

Format Cells and Layout in Google Sheets

Format a readable sheet and use custom number formats in Google Sheets with a reproducible practice example and outcome checks.

Documentation-reviewed candidate; native application verification not performed. · Editorial standards

Quick answer

Use toolbar formatting to make a sheet readable, and Format > Number to control numeric display. A custom number format changes presentation, not the underlying quantity or the result of arithmetic.

Prepare numbers and labels before styling

Use an editable native Google Sheets spreadsheet in the desktop web app. This guide uses a United States-locale practice file so decimal points and expected displays are unambiguous. Custom-format dialogs and defaults can differ from mobile controls and other locales; no mobile parity is assumed.

Enter this table at A1:

Item	Amount	Completion	Note
Starter kit	1234.5	0.25	Review the sample packaging description
Credit	-12.5	0.5	A negative adjustment, not an expense
No charge	0	1	Keep zero distinct from a blank cell

In F1 enter Amount check; in F2 enter =SUM(B2:B4). It should calculate 1222. Keep a copy of the unformatted inputs before experimenting. Formatting the data will not change that total.

Build a readable hierarchy

Select A1:D1 and use toolbar Bold with a restrained fill and contrasting text.
Select D2:D4 and enable toolbar text wrapping. Adjust the column width until the complete notes can be read without reducing the font excessively.
Use the border control to distinguish the header from the records. Avoid a heavy border around every cell.
Align text consistently and keep numeric columns visually aligned. Do not merge data cells to center a label; that would make later sorting and selection harder.

The Credit row explains the negative value in words. Red text alone would not communicate the meaning to every reader or survive every print setting.

Apply custom number and percentage displays

Select B2:B4 and choose Format > Number > Custom number format. Enter #,##0.00;[Red](#,##0.00);0.00 and apply it. This uses separate positive, negative and zero sections. In the stated locale the expected displays are 1,234.50, (12.50) in red, and 0.00.

Select C2:C4 and apply the custom number format 0.0%. Expected displays are 25.0%, 50.0%, and 100.0%. The inputs remain 0.25, 0.5 and 1. Do not replace 0.25 with 25 merely because a percentage sign is shown.

Inspect F2 again: it must still be 1222. For a precision check, change B2 to 1234.567. Its display rounds to 1,234.57, but F2 calculates 1222.067 before any display rounding of its own. Restore B2 to 1234.5 for the final copy.

Keep the final sheet and diagnose exceptions

After online saving, reopen and inspect the wrapped notes, negative number and zero. Check the formula result separately from the display. If a custom format seems ineffective, determine whether the cell contains text rather than a numeric value. A format cannot recover digits or leading zeros already lost during import.

If the separator or currency default is unexpected, inspect the spreadsheet locale before typing punctuation into every value. A fixed custom currency display is available through Format > Number > Custom currency, but a symbol does not convert an amount between currencies.

For a reversible recovery drill, use a duplicate tab and change B2:B4 back to a normal number display. The same inputs and F2 total should remain. Keep the carefully styled original intact; do not erase its contents to remove a visual format.

For identifier transport rather than numeric appearance, see import CSV while preserving product IDs. This guide does not recreate the table or named-range workflow.

Official references

Documentation basis: first-party extracted snapshots retrieved 20 October 2026. The fixture expectations were checked independently; no native Google Sheets session, account action, screenshot or export was executed for this article.