View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Bonallack[_2_] Daniel Bonallack[_2_] is offline
external usenet poster
 
Posts: 27
Default Decreasing/Increasing decimal places

One of my colleagues has asked for a macro that will
increase or decrease the number of decimal places of a
number. I know the toolbar button does this very nicely,
but he wants a short-cut key.

So if the number is 54.37, he wants code (executed by
shortcut keys) that will decrease/increase the decimal
places by one each time he runs it.

Thanks in advance for any help.

regards
Daniel