I have a scroll bar connected to a cell which changes the dollar value shown
in the cell. The problem is it only shows dollars and 00 cents. Is there a
way to change the properties of the bar to change by the penny, not just by
the dollar?

How about adding another helper cell that divides the linked cell by 100. (Then
hide the linked cell.)


Doug wrote:

I have a scroll bar connected to a cell which changes the dollar value shown
in the cell. The problem is it only shows dollars and 00 cents. Is there a
way to change the properties of the bar to change by the penny, not just by
the dollar?

--

Dave Peterson

If you divide 1000 by 100 you still don't have any decimals. I created 2
scroll bars, 1 for dallars, 1 for cents. For cents I set the max at 99 and
divided that by 100. Now I add the 2 cells to get a total. This works but
it means using 2 scroll bars. I was hoping to do it with one scroll bar.

"Dave Peterson" wrote:

How about adding another helper cell that divides the linked cell by 100. (Then
hide the linked cell.)


Doug wrote:

I have a scroll bar connected to a cell which changes the dollar value shown
in the cell. The problem is it only shows dollars and 00 cents. Is there a
way to change the properties of the bar to change by the penny, not just by
the dollar?

--

Dave Peterson

Format the cell with the divided by formula to show 2 decimal places.

Say you want 0.00 to 10.00
Then set the limits for the scroll bar to 0 and 1000.
Then use =a1/100 and format that cell to 2 decimal places.
(a1 is the linked cell that will show between 0 and 1000).



Doug wrote:

If you divide 1000 by 100 you still don't have any decimals. I created 2
scroll bars, 1 for dallars, 1 for cents. For cents I set the max at 99 and
divided that by 100. Now I add the 2 cells to get a total. This works but
it means using 2 scroll bars. I was hoping to do it with one scroll bar.

"Dave Peterson" wrote:

How about adding another helper cell that divides the linked cell by 100. (Then
hide the linked cell.)


Doug wrote:

I have a scroll bar connected to a cell which changes the dollar value shown
in the cell. The problem is it only shows dollars and 00 cents. Is there a
way to change the properties of the bar to change by the penny, not just by
the dollar?

--

Dave Peterson


--

Dave Peterson