Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel
Message
From
07/05/2002 11:34:53
Della Martin
Cary, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Excel
Miscellaneous
Thread ID:
00653196
Message ID:
00653551
Views:
34
To emulate VFP's PADL() function, try 
oSheet.Columns["A:A"].NumberFormat = "000"
The number of zeroes in the string fixes the number of places to display. The above format shows a numeric value of 1 as 001.

- della
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform