HOW TO CHANGE CELL PROPERTIES IN EXCEL

[fluppe689]

Hello Experts

I made program that is making an excel sheet.
Sor far not problem.
My dbf table exist from 2 columns

column1 c(20)
column2 n(10)

The problem is when in column1 there is
123456789123456789
in the excel cell there find 12345E+8

How can i change the format of the cell into text

wfg,

Filip

 

[markros]

Set the NumberFormat property of the column. Also why you're asking this question in SQL Server forum, may be you would have better luck in Excel forum?

 

[JRB-Bldr]

Sometimes a number appearing like 12345E+8 within Excel is not a formatting issue, but merely a column width issue.

I'd suggest that you get a copy of Microsoft Office Automation with Visual FoxPro (

http://www.hentzenwerke.com/catalog/autofox.htm)

It will teach you how to do a whole host of Office/Excel Automation operations.

Good Luck,
JRB-Bldr

 

[Nifrabar]

Filip,

For what it's worth:
I see your column1 is expecting characters.
If you just enters 123456789123456789 into an excel cell it is expected to be numeric with the result (1,234567E+17) you are facing.
If you put an aposthrope in the cell prior to the numerics excel will treat the cell-contents as character with the result you like to see.

-Bart