Re: Combo Box - HELP

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
.

Relevant Pages

  • Re: Combo Box - HELP
    ... >> What version of excel are they using. ... >> If they're using xl97 or later, ... >> ynissel wrote: ... >> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: general macro question
    ... ynissel wrote: ... so basically my only option is to store it in another excel file and open ... "Dave Peterson" wrote: ... the macro menu option - I dont see any macro? ...
    (microsoft.public.excel.misc)
  • Re: general macro question
    ... ynissel wrote: ... "Dave Peterson" wrote: ... Is there any way to see where/how it launches excel? ... the macro menu option - I dont see any macro? ...
    (microsoft.public.excel.misc)
  • Re: general macro question
    ... "Dave Peterson" wrote: ... ynissel wrote: ... so basically my only option is to store it in another excel file and open ... the macro menu option - I dont see any macro? ...
    (microsoft.public.excel.misc)
Loading