View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
 
Posts: 259
Default Change cell type

Derick

Try

Range("K2:K10").Select
Selction.NumberFormat= "0.00"

HTH
Mick.