View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tumbleweed Tumbleweed is offline
external usenet poster
 
Posts: 15
Default Formating Cells in VBA

Range("Sheet1!C7:C17).NumberFormat = "$#,##0.00"


"Greg Bloom" wrote in message
news:ldJbb.547825$Ho3.95541@sccrnsc03...
How do I format a cell to be currency with VBA Code?