Combo box

[Stephen]

Hi,

Can anyone help with me how to display a % number in a
combobox? Everytime I refer to a %range, it shows the %
number in a comma format in the box and the cell the
combox is linked to is also displayed in a comma format.
For some reason excel will not let me format the target
cell from comma to %.

Would appreciate any help very much.

Thanks,
Stephen

 

[steve smallman]

Stephen,

Your combo box output will probably be text. You will
need to store the value in a cell, and convert it to
numeric format to use in calcs. When I ran a couple of
tests, I could bring up the % value, but the box stored
and linked the value as text. Even entering the values as
% ie "30%" in the list cells didn't help.

Steve