ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Abu Bakar Ashfaq , Senior Consultant , PricewaterhouseCoopers Middle East
تاريخ النشر: 2016/02/07
Pankaj Kumar Dash
من قبل Pankaj Kumar Dash , Lead Technical Analyst and Programmer , COLT Technology

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

 

Remees Raj
من قبل Remees Raj , Data Manager , National Institute of Mental Health and Neurosciences

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.

ben abdallah faouzi
من قبل ben abdallah faouzi , Responsable ressources humaines , Groupe JBG

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

khaled rezk
من قبل khaled rezk , mechanical site engineer , ayman omar office

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

redouane ouali alami
من قبل redouane ouali alami , مراقب , true restore

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

Mohammad Hosseini
من قبل Mohammad Hosseini , Project Planner , nbn

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

Aftab Anjum
من قبل Aftab Anjum , Senior Accountant/Consultant , Concord Accounting & Bookkeeping LLC

Select the Cell and Press Ctrl + ;

Asif  Bherani
من قبل Asif Bherani , Assistant Manager, Information Systems Unit , The Aga Khan University

press ctrl+shift+# at once

Jamal Kamal
من قبل Jamal Kamal , Reservation Manager , Barakat Travel & Tourism

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.

ABDUL QADEER AWAN - ACA FCCA CPA
من قبل ABDUL QADEER AWAN - ACA FCCA CPA , Finance Manager , CORE Investment Company

To insert date press ctrl + ;

المزيد من الأسئلة المماثلة