how to have a default value displayed in excel list

[punkS]

I created a drop down list in three cells for date, month and year using data validation.


But I need these cells to display by default DD,MM,YYYY.


what's the way to do it.


thanks in advance

 

[Sajan]

Hello @punkS,

To setup a default value, you could just save the Excel file with DD, MM, and YYYY in those cells, and ensure that your drop down list also contains those as a choice (say the first choice).


If that is not practical, someone on this forum might be able to supply you some VBA code to control the default display.


Cheers,

Sajan.

 

[NARAYANK991]

Hi ,


Can you not use the Input Message feature of the data validation to display the required message when the drop-down cell is selected ?


I assume that you wish to display the default format to assist the user.


Narayan