Changing format of date

  • Hi ALL,


    I have many rows of data which I got from my server and the date format (of date related fields) in these fields are mm/dd/yy. So in excel, 09-Mar-05 appears as 03/09/05.


    Is there a way thatI can change all these rows to dd-Mmm-yy format so that in Excel i see the data as 09-Mar-05 rather than 03/09/05.


    Regards.

  • Re: Changing format of date


    Hi J,


    Once a cell is formatted as "dd-mmm-yy" It should display as 09-Mar-05 only.


    Of course, in the formula bar it will display as 03/09/05, which I don't think one can change, as this is the System default.


    HTH.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!