Thread: How to format column 7 ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
  
Posts: 2,494
Default How to format column 7 ?
Columns(7).NumberFormat = "#.00.00"

--


Gary


wrote in message
ups.com...
In VBA, if I have the integer 7, how do I format column 7?

The recorder does

Columns("G:G").Select
Selection.Numberformat = "blah"

Thanks.



Reply With QuoteReply With Quote