Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numberformat in Excel Automation
Message
From
19/07/2002 06:27:13
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
Numberformat in Excel Automation
Miscellaneous
Thread ID:
00680345
Message ID:
00680345
Views:
65
Hi All,
I am trying to format a cell in Excel from VFP. It all works fine untill I tried to take a numeric cell and format it in a number + "Days" style.
In Excel I would go to format cells, select a custom category and write: #,##0 "Days", but in VFP, since the whole format must come within inverted commas I tried "#,##0 Days" and it produced an error. I also tried "#,##0 'Days'" but no luck.
Any ideas?
Thanks in advance
Jonathan
Next
Reply
Map
View

Click here to load this message in the networking platform