I have a Combo Box that has a linked cell reference to a
cell that contains a date value. The Date Value is "=NOW
()" by the way.

The combo box is displaying the numeric date value - how
can I format this to read as a date?

I also wanted to then use an up down control (or even
better one of those controls that lets you pick a date
off of a calendar).

So how do I make it display a date and how do I let the
user modify this existing date?

Thanks