I have a page that outputs a html table to excel using
Response.ContentType = "application/vnd.ms-excel"
and it works great but I noticed that one column gets treated as Number (as Excel likes to do) and I want it to see it as Text in order to prevent leading zeros from being deleted. any ideas?
Results 1 to 2 of 2
Thread: Output to Excel
-
5 Star Lounger
- Join Date
- Jan 2001
- Location
- austin, Texas, USA
- Posts
- 1,029
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-10-21 15:51Output to Excel
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Silver Lounger
- Join Date
- Jan 2001
- Location
- Indianapolis, Indiana, USA
- Posts
- 1,862
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-10-21 16:15Re: Output to Excel
Add an apostrophe to the beginning of the value for that cell:
00123 = '00123
Excel will always display values as text that start with a leading apostrophe.<big><font color=blue>- M</big><font face="Comic Sans MS">ark</font face=comic><big>J -</big></font color=blue>
<IMG SRC=http://www.wopr.com/w3tuserpics/MarkJ_sig.gif border=0>
