Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
This guide describes how to grey out unused cells in Excel in Windows 11/10, apply a solid fill color, use Conditional Formatting, or hide unused rows/columns.
Jump LinksRepeat the previous formatting step with F4Duplicate or replace formatting on a bigger scaleUse cell styles for ...