Skip to content

Hosted by Dailymotion. For legal issues: Copyright Center · DMC · Instant Removal

In Excel which key is used for format number in da

M
Muhammad Imran

2 Views • Mar 10, 2025

Description

In Microsoft Excel, you can quickly format a number as a date using the Ctrl + Shift + # shortcut. This applies the standard date format (e.g., DD-MMM-YYYY, like 10-Mar-2025) to the selected cell.

Excel provides several formatting shortcuts to enhance efficiency, including:

Ctrl + Shift + $ → Currency format
Ctrl + Shift + % → Percentage format
Ctrl + Shift + ^ → Scientific format
Ctrl + Shift + # → Date format
Using these shortcuts makes it easier to organize and present numerical data in Excel.