أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
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.
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 + ;