I have a list of dates that people should be allowed to select from. the cell is with the validation is formatted as a date cell, so it looks fine after someone has selected a date.
But... the list shows the excel value, not in date format. I need it to show the list in date format, because otherwise people aren't going to have a clue what to pick.
The list it's pulling from is in date format, so that's not the issue. And I have calculations based on this selection, so I can't change it to words.
Screen shot attached of the issue
This doesn't seem to affect excel 2007 or 2010. But I need a workaround for 2002.
vba is ok, but please make it easy because anything too complex just breaks. Thx :)