SOT : Leading 0's in csv file

I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc. Is there any way I can output the .csv so that it retains that leading 0 when I bring it into excel? (My gut feeling is no, but I

RE: SOT : Leading 0's in csv file

Use List qualify and add double quotes around each cell value. Stace -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:29 AM To: CF-Talk Subject: SOT : Leading 0's in csv file I'm building a csv file and the data has a leading 0 in front

RE: SOT : Leading 0's in csv file

I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc. Is there any way I can output the .csv so that it retains that leading 0 when I bring it into excel? (My gut feeling is no, but

Re: SOT : Leading 0's in csv file

make the cell text when you import On Tue, 18 Jun 2002, Tim Painter wrote: I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc. Is there any way I can output the .csv so that it

Re: SOT : Leading 0's in csv file

PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 11:52 AM Subject: RE: SOT : Leading 0's in csv file I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc

Re: SOT : Leading 0's in csv file

Just had a recent thread on this: Try putting a ` in front of the number(s) in the .csv file... I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc. Is there any way I can output