Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to.

As a result, if you apply the Accounting number format to a whole column or row that contains text as well as financial values, remember to revert those non-numerical cells to the Text format.

By default, this is set to Black. You can manually change the text color for part of the text or the entire text in your Excel data using the Font Color option.

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.

You can add a strikethrough in Microsoft Excel using the software's Font Settings button or a keyboard shortcut.