Excel Formatting Question: Custom formatting for Text

Riny_van_Eekelen 

Hi Riny,

many thanks for your answer.
I would have the whole word in the drop down list (e.g. Vacation). If you select it will be filled in the cell.

If you have a calendar overview for many people for a whole month or more, it's quite easier to have only the first letter shown in the cell.
The other way round you would have the first letters only in the drop down list.
At the end it's a question of user-friendliness and better overview. 🙂

However, it was a nice try to challenge Excel functionality.
The workaround will be a duplicate table where I will use the LEFT function.
If you have a better idea, let me know.
Regards
Markus