Excel
Word
PowerPoint
Outlook
Google Sheets
Google Docs
Google Slides

Decrease Decimal Places

Remove one decimal place from the number format of selected cells.

Keyboard shortcut by app

App Windows Mac
Microsoft 365
Excel
Alt+H+9
 Not available
Word Not available Not available
PowerPoint Not available Not available
Outlook Not available Not available
Teams Not available Not available
Google Workspace
Google Sheets Not available Not available
Google Docs Not available Not available
Google Slides Not available Not available
More in Number Formatting
Apply Accounting Format Apply Currency Format Apply Date Format Apply General Number Format Apply Number Format with Two Decimals Apply Percentage Format Apply Scientific Notation Format Apply Time Format Increase Decimal Places Open Format Cells Number Tab

Popular Functions

Hand-picked function guides that work in both Excel and Google Sheets.

SUMIF Function in Excel & Google Sheets (Syntax + Examples) SUM Function in Excel & Google Sheets (Syntax + Examples + Fixes) FORECAST Function in Excel & Google Sheets FILTER Function in Excel & Google Sheets (Syntax + Examples + Fixes)