Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Format Cell problem
Message
From
10/06/2011 04:19:17
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
10/06/2011 04:00:52
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
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:
01513980
Views:
52
>I try this,
>
>oExcel.activesheet.Range("B"+TRIM(PADR(nrow,11))).NumberFormat = [0000000000]
>
>
>The cell can dispay 000234567, but the cell is still in numeric format.
>
>How to set the cell to a text format and can display leading zero ?

Prefix it with an apostrophe: 
oExcel.activesheet.Range("B"+TRANSFORM(nrow)).value = ['000234567]
back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform