You need to play with this, but I think that you will need to put normal double quotes around the strings if you want to force them to strings.
XYZ "0002393" More to the point, all the strings should have quotes. "XYZ" "0002393" Dave S ----- Original Message ----- From: zonnykft To: [email protected] Sent: Friday, July 08, 2005 8:36 PM Subject: [ASP] Single quote problem 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! --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "active-server-pages" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [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/
