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 Classic Menu
• Find the feature on Ribbon interface

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

With Classic Menu for Excel 2007/2010/2013/2016/2019 installed, you can click Menus tab to get back the classic style interface.

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

• Click Format menu
• Click Format Cells, and then the Format Cells window will pop up. (Figure 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 2)

Fig. 1

Fig. 2

---

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

• Click Home tab
• Move to Cells group; choose Format and click the arrow next to it (Figure 3)
• Click Format Cells, you can get the Format Cells pop up window as Figure 2 shows

Fig. 3

---

More Related Articles...

• Where is Conditional Formatting
• Where is Page Setup
• Where is Tools Menu
• Where is Undo
• Where is Macro
• Where are Pivot Table and PivotChart Wizard
• Where is Print Preview
• Where is Help Button
• Where is Goal Seek
• Where is Edit Menu
• Where is Decrease Decimal Button
• Where is Specify Decimal Place

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You 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 Menu for Office It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365.
		Classic Menu for Office 2007 It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Screen Shot of Classic Menu for Excel