Formatting macro required
 

I would like a macro that will format any selecred cell : It should
format as a NUMBER of 2 decimals
Thanks

Formatting macro required
 

Activecell.Numberformat = "#,#00.00"

--

HTH

Bob

"pcor" wrote in message
...
I would like a macro that will format any selecred cell : It should
format as a NUMBER of 2 decimals
Thanks

Formatting macro required
 

On Jun 29, 3:18*am, "Bob Phillips" wrote:
Activecell.Numberformat = "#,#00.00"

--

HTH

Bob

"pcor" wrote in message

...



I would like a macro that will format any selecred cell : It should
format as a NUMBER of 2 decimals
Thanks- Hide quoted text -

- Show quoted text -

If you want it to be truly automatic, put within a
worksheet_selectionchange event macro in the sheet module.