Formatting macro required

P

pcor

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

Don Guillett Excel MVP

Activecell.Numberformat = "#,#00.00"

--

HTH

Bob






- Show quoted text -
Click to expand...

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