Selection.NumberFormat = "#,##0.00"
or
Range("A1:E3").NumberFormat = "$#,##0"
for example...
Is this what you're looking for?


"Wayne Ware" wrote in message
...
I am new to Visual Basic for please forgive the "rookie" question.

I have a range of cells in an Excel spreadsheet that I need to format
from a Visual Basic program. Can someone provide a brief example of
how to do this? Or point me to some online documentation that would
help?

Thanks in advance.

Wayne