FG
šŸ’» Software

how to change 0's to -'s for a selected block of cells

Fresh5 days ago
Mar 15, 2026127536 views
Confidence Score0%
0%

Problem

I want to change the formatting on an excel sheet so that 0's will show up as dashes for only a specific block of cells on a sheet. Does anyone know how to do this? Note that I do not want this formatting for the entire sheet, only for a certain block of cells.

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix ā€“ Awaiting Verification

Fix for: how to change 0's to -'s for a selected block of cells

Low Risk

If you only want to change the formatting, not the content, of the cells you should look at the Accounting format type, but with no symbol selected. All cells with a value of will be displayed as while keeping the value in the cell. But Accounting dā€¦

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment