I am using a few comboboxes on a worksheet to provide a picklist vice the
validation data. The combobox solved a problem with an inability to control
the font size with the worksheet is set at 66%. There is a large amount of
data on this worksheet and I've set it up to show as much data as possible in
this application. I am having a small problem with building the lists. Each
combobox has a linkedcell associated with it. I have several list with
values like 100%, 110%, 120%, etc. and when the end user picks a value the
linkedcell ends up with '100%, '110%, etc. as text instead of an integer or
percentage value. I have setup the linkedcell with the correct format but
still it ends up with a text value. Anyone know how to direct Excel to make
the value picked as a integer or percentage value? BTW, the reason for the
combobox is that validate data lists have the fonts way too small and there
is not a way to control the font size.

Sincerely,

Bryan44