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.


  • 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.


Participate now!

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