Try browsing through the answers provided by this search.

http://www.google.com/groups?as_q=Fo...n&num=50&hl=en

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Hello-

I have a combobox that is pulling a rowsource from a named range of dates
(1/12003, 1/2/2003, etc). The list displays fine, but when you select one
it shows up in the box as the value of the date (eg 37712).

Thanks