Thread: Formatting macro required
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
  
Posts: 834
Default 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


Reply With QuoteReply With Quote