Hi All,

Could some body pls help me with the following problem.

I am using Visual Studio to create an Excel file (i.e. the file has an .xls extension with a TAB charactor between the cells).

However I lose the formatting on numeric cells, see example :-

1) I put the value 123.40 in a cell, but when opened the file I see 123.4

2) Also same with 00100, when opened I see 100

Does any one have the answer to this ?

Also, on the same lines, can I left justity numeric fields, as it always right justifys it.

Many thanks for any help,

Neil.

Unless you actually create a real excel file, you won't be able to specify the formatting of the sheet. All you are creating is a character delimited text file that happens to open in Excel. You would probably get the same results if you made the file with a CSV extension.

You might be able to interact directly with Excel objects and create a new document and sheet, add values to the cells and specify the formatting. I don't know how to do this however.

-Peter

check out http://www.greggriffiths.org/webdev/both/excel/ for some examples of this.