How To Change Number Of Decimal Places In Excel

Home > Documents > Excel > Where is Specify Decimal Place in Excel 2007, 2010, 2013, 2016, 2019 and 365

Where is Specify Decimal Place in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

Find the feautre on Archetype Card
Find the feature on Ribbon interface

Utilize the familiar Excel 2003 style if you have Classic Menu for Excel installed.

With Classic Menu for Excel 2007/2010/2013/2016/2019 installed, y'all tin can click Menus tab to become back the classic style interface.

If you want to specify the Decimal place, just follow the steps below:

Click Format bill of fare
Click Format Cells, and and so the Format Cells window will pop upward. (Effigy 1)
Click the Number tab, choose Number item in the Category list, and you will find the Decimal Place in the right part of the window. Here you can specify the decimal places for a built-in number format.(Figure two)

Fig. 1

Fig. 2

If you have non Classic Menu for Excel 2007/2010/2013/2016/2019 installed, you can …

Click Home tab
Move to Cells grouping; cull Format and click the arrow next to information technology (Figure 3)
Click Format Cells, you can become the Format Cells popular upwardly window as Figure 2 shows

Fig. 3

Classic Menu for Part

Brings the familiar classic menus and toolbars dorsum to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. Yous can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.

Classic Carte for Office

Information technology includes Archetype Carte du jour for Discussion, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365.