>>Once I have created an Excel object and opened my spreadsheet......
>>
>>How can I select a column and set the format to Numeric, 2 decimal places.
>>
>>Thanks to all.........Rich
>
>
>oSheet = oWorkbook.ActiveSheet
>oSheet.Range("D:D").NumberFormat = "#,##0.00"
>
Got it.
Thanks again