Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications
Date Posted: 2013/09/29
Jayson Aglubat
by 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
by 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
by 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.

More Questions Like This