To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

In the Type box you’ve probably got “General” Find the format #,###0; [Red]-#,###0 (in Excel 2003, it’s at the bottom of the screen) Put it into the Type box. After the zero at the far right, type: ...