MrExcel.com - Your One Stop for Excel Tips & Solutions

change format in list validation dropdown

Posted by Travis on October 09, 2001 12:18 PM

I have a "list" validation on a cell in which I have entered the last day of every month for the list. In the drop down it is displaying in format "dd-mmm" is there a way to make this show as "m/dd"
Thanks in advance

Posted by Aladin Akyurek on October 09, 2001 12:28 PM

Travis,

Put the items of your list somewhere else. Select that range and custom format it as m/dd. Type in Data Validation window as Source of your list the range you just created.

Aladin