Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formatting a column in Excel
Message
From
10/09/2007 14:45:35
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01253496
Message ID:
01253510
Views:
25
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform