New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Formatting›Format negative numbers

Google Sheets · Verified tutorial

Format negative numbers in Google Sheets

Format A2:A4 so negative numbers appear in parentheses using 0;(0).

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Format A2:A4 so negative numbers appear in parentheses using 0;(0).

Step-by-step

1

Select the targetFormat A2:A4 so negative numbers appear in parentheses.

2

Apply the change0;(0).

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A2:A4 uses the requested negative-number pattern.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A2:A4 and repeat the final action. A2:A4 uses the requested negative-number pattern.

Example spreadsheet data

This is the clean fixture used for the verified run.

Change

-120

85

-42

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Format A2:A4 so negative numbers appear in parentheses.
Apply the change. 0;(0).
A2:A4 uses the requested negative-number pattern.