What is the shortcut of insert date in this format? (31-Jan-9999)

To insert date in - DD-MM-YYYY format - press ctrl + ;

Select the cell you want to format and press Control+Shift+#

CTRL + Shift + F then go to the first tab Numbers > Date

If the date format you like is not available on the list use Custom, for the date format you like use dd-mmm-yyyy.

SELECT A CELL PRESS CELL FORM THEN DATE AND DD/MMM/YYYY

select the cell and press ctrl+Shift+3 at once.

We form a date to DD-MM-YYYY and then click on ctrl+ shift

The shortest way to have date format is to select the cell and press ctrl+Shift+3 at once.

Select the Cell and Press Ctrl + ;

press ctrl+shift+# at once

To format a date, while the cursor is on the cell you want to format, press Ctrl +1. That would open up the format cell option box. Choose the “Number” tab and click on “Date”. In the “Type”, select the format you like.

To insert date press ctrl + ;