Thread: how to define decimal places in macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default how to define decimal places in macro?
hi
try....
range("A2:E20").NumberFormat = "0.00"

regards
FSt1

"Oligo" wrote:

how do i define the cell A2:E20 to have 2 decimal placing??


Reply With QuoteReply With Quote