View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Atherton[_26_] Peter Atherton[_26_] is offline
external usenet poster
 
Posts: 2
Default Increase decimal macro

something like

c=c.offset*17.5%
c.numberformat="0.00"

Peter
-----Original Message-----
I have the following problem:
I often want to change the position of the decimal place

in a cel (i.e.,
change its NumberFormat). However, i am too lazy to use

the toolbar button.
Instead, I need something i can bind to a shortcutkey.

Unfortunately,
recording the macro yields no interesting results.

Is there a simple, general way to do what I am thinking

of, or must the code
for such a macro be necessarily long?

Any help would be appreciated! Thanks.


.