Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combo Box - HELP
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 |
#2
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box - HELP
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box - HELP
If you want continue to use =mround(), then you'll have to have that analysis
toolpak installed. ynissel wrote: 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box - HELP
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" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box - HELP
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 "Peo Sjoblom" wrote: 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" wrote in message ... 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box - HELP
Yes
=ROUND(A1/0.125,0)*0.125 -- Regards, Peo Sjoblom "ynissel" wrote in message ... 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 "Peo Sjoblom" wrote: 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" wrote in message ... 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box - HELP
Perfect - thanks so much !!
Any thoughts on why my conbo box formatting isnt working on some people's machines ? "Peo Sjoblom" wrote: Yes =ROUND(A1/0.125,0)*0.125 -- Regards, Peo Sjoblom "ynissel" wrote in message ... 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 "Peo Sjoblom" wrote: 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |