P pcor Jun 29, 2010 #1 I would like a macro that will format any selecred cell : It should format as a NUMBER of 2 decimals Thanks
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 Jun 29, 2010 #2 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.
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.
