View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Scrollbar changing dollars

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