Dear
A B C D
Date Month Year Arr_date
13 5 2016 =date(c2,b2,a2) - it shown 2016-5-13

However, i would like to show as "May-13 " ( i need to show the month and year, as i then take this for Pivot Table , so i need that just MMM-YY


How can i do that ?



Eric

There is no point in changing the format of your source data. You can change it in the Pivot Table to the desired custom format mmm-yy

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post