Correct . You need to format any text, dates or numbers before you add them
to the combo or list box

--
Patrick Molloy
Microsoft Excel MVP

"J Tulk" wrote in message
...
Is there any way to format the contents of a combo box? I
am using EXCEL 97. The format of the list has no effect
on the format in the combo box. The combo box doesn't
seem to have any properties except size.