| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting macro required
I would like a macro that will format any selecred cell : It should
format as a NUMBER of 2 decimals Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting help required... | Excel Worksheet Functions | |||
| Conditional Formatting help required | Excel Discussion (Misc queries) | |||
| Conditional formatting help required please | Excel Discussion (Misc queries) | |||
| Object required when formatting | Excel Programming | |||
| Formatting userform textbox - help required | Excel Programming | |||
![pcor[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
