Just a thought... Is it possible to "format" the excel column? Lisa
Hi all, I'm creating ASP application to write into a tab-delimited file to be read by Excel. This is the requirement, don't ask me why :-) The desired output should be something like: XYZ 0002393 The problem is when I open the output file using Excel, it becomes: XYZ 2393 I know that in Excel we need to put single quote to explicitly indicate a value as a string. But when I purposely throw single quote in the ASP code, it becomes: XYZ '0002393 The single quote is also displayed! In either case, that's not the desired outcome. Is there anything I can do? thanks! [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
