Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Format Cell problem
Message
From
10/06/2011 04:43:47
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
To
10/06/2011 04:19:17
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Excel Format Cell problem
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01513977
Message ID:
01513982
Views:
43
Hi,

I put a prefix ' before the invoice no.
oExcel.activesheet.Range("B"+TRIM(PADR(nrow,11))).value = "'"+rpt012->invno
Yes, the cell can display 000234567, but the value become '000234567
I don't want it be '000234567

Please advise.

Derek Yim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform