What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.

ynissel wrote:

I send this file to other users who dont necessarily have the same version
excell as I do - and this is causing an error message to appear. Can this be
overcome ?
Thanks.

"Dave Peterson" wrote:

That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.

ynissel wrote:

I have a combo box that I formatted 0.000% and it works great. But the cell
its linked to - which is also formatted as % to 3 decimal places wont format
as a % - and thats a displayed cell so I need it to format properly.

any ideas ??

Thanks,
Yosef

--

Dave Peterson


--

Dave Peterson