Scrollbar changing dollars

[Doug]

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]

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

 

[Doug]

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]

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