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

2] Remove dashes in Excel by using the Find and Replace method This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

Image: 200dgr/Shutterstock The article, Use a custom format in Excel to display easier to read millions uses a custom format to make large values more readable. For instance, 1,200,000 displays as ...