Re: Combo Box - HELP

Im not sure of their version but it seems to be an issue.
The other issue I have is that I used the MRound function in the file and
since its an ADDIN in the analysis tool pack many users of my file get errors
! Is there a way around this without making them install the add-in ?
Thanks,
Yosef

"Dave Peterson" wrote:

> 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
>
.