How to change the default number format in excel

The tutorial explains the basics of Excel format for number, text, currency, percentage, accounting number, scientific notation, and more.

Also, it demonstrate quick ways to format cells in all versions of Excel 365, 2021, 2019, 2016, 2013, 2010, 2007 and lower.

When it comes to formatting cells in Excel, most users know how to apply basic text and numeric formats.

But do you know how to display the required number of decimal places or a certain currency symbol, and how to apply just the right scientific notation or accounting number format?

How to format a column in excel with a formula

And do you know the Excel number format shortcuts to apply the desired formatting in a click?

Excel Format basics

By default, all cells in Microsoft Excel worksheets are formatted with the General format.

With the default formatting, anything you input into a cell is usually left as-is and displayed as typed.

In some cases, Excel may not display the cell value exactly as you've entered it, though the cell format is left as General.

For example, if you type a large

how to format cells in excel based on another cell

how to format cells in excel based on text