how to define decimal places in macro?

[Oligo]

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

 

[FSt1]

hi
try....
range("A2:E20").NumberFormat = "0.00"

regards
FSt1

 

[Shane Devenshire]

Hi,

Try

[A2:E20].NumberFormat ="0.00"

 

[Bob Flanagan]

Range("a2:e20").numberformat ="0.00"

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel