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

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

متابعة

How to change date format from dd-mm-y to dd-mm-yy in formula bar of ms-excel?

user-image
تم إضافة السؤال من قبل Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications
تاريخ النشر: 2013/09/29
Jayson Aglubat
من قبل Jayson Aglubat , Creative Artist , Sadeem International Co.Ltd.

On format cell you can select an option which date format  and this format cells can be found in more number options of number standard tool bar from home toolbar.

rudra bhattarai
من قبل rudra bhattarai , teacher , niit

select cell and click on format cell ..

a dialog box appear..

under the number tab ...select date 

and choose your suitable option ...

Muhammad Usman Usman
من قبل Muhammad Usman Usman , Sr. IT Network Support Engineer , Imtiaz Super Market

First of all select cell, then remove value after, insert new value. And2nd option is on Standard button and go to Formate Cell button.

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