I remember running into the same issue before. If memory serves me correctly: I think I just concatenated a space before the number. This has been over 2 years, so I won't guarantee it, but it should be a simple test to verify. HTH in some way Andy
> -----Oorspronkelijk bericht----- > Van: [email protected] [mailto:active-server- > [EMAIL PROTECTED] Namens zonnykft > Verzonden: Friday, July 08, 2005 12:37 PM > Aan: [email protected] > Onderwerp: [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! [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/
