Combo Box - HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That combobox's value is text.

Maybe you could use a helper cell that points at the linked cell:
=--a1/100
Formatted nicely.
 
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.
 
What version of excel are they using.

If they're using xl97 or later, then this isn't the problem.
 
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
 
If you want continue to use =mround(), then you'll have to have that analysis
toolpak installed.
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
Click to expand...
 
Regarding MROUND, you can get the same result using built in functions
but we need to know how you want to round first

--

Regards,

Peo Sjoblom

ynissel said:
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
Click to expand...
 
I always need to round to the nearest 1/8th.
So my function is mround(a1,.125)
Is there a built in function that can do the same thing ?
Thanks,
Yosef
 
Yes

=ROUND(A1/0.125,0)*0.125


--

Regards,

Peo Sjoblom

ynissel said:
I always need to round to the nearest 1/8th.
So my function is mround(a1,.125)
Is there a built in function that can do the same thing ?
Thanks,
Yosef
Click to expand...
 
Perfect - thanks so much !!
Any thoughts on why my conbo box formatting isnt working on some people's
machines ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box - How to Use Output in Vlookup 4
Combo Box Formatting 4
Find 0.00% 1
Control Box - Please help ! 3
Add a combo box 1
Copying Combo Boxes?! 5
Combo Box - format output as time 1
Combo Box 2

Back
Top