Hi Imar,

I am exporting data to excel using asp. While I am exporting to excel, I am missing zero values at the begining of the numbers. For example in database Id= 03456, when I export it to excel, it display as Id=3456. I can't keep the number as it is in database. And how do you format the excel like the way you want? For example: lines between cells or characters styles.

Can you or someone please help? Thank you in advance.

Not sure why you're addressing me directly, but anyway, here's an answer.

03456 is not a number. 3456 is. AFAIK, no number has leading zeros like this. So, I think Excel does the right thing and strips of the leading zero. If you want to keep it, prefix the data with a ' to tell Excel you mean the literal value of the data. '03456 will be visible as 03456 in an Excel cell (no pun intended, although I think the people at Microsoft did)

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Everything Ends by Slipknot (Track 5 from the album: Iowa) What's This?