RE: [PHP] PHP, Excel, and tab delimited files question

Nah... Try it in excel itself and you'll see what I'm talking about. You have to do it in numeric fields. Do this in an excel field: - Type 000010 and hit return. ... It becomes 10, right? Now try it like this: '000100 ... Tada! It stays as 00100 and puts a little green tab in the top left corner. There's no closing ' in this example, just the opening one at the beginning of the text. Hope that helps... 'course, I'm using excel 2002, so maybe different versions do different things... -- jon -----Original Message----- From: Marek Kilimajer [mailto:kilimajer@webglobe.sk] Sent: Friday, February 06, 2004 3:02 PM To: Jay Blanchard Cc: jon roig; php-general@lists.php.net Subject: Re: [PHP] PHP, Excel, and tab delimited files question Do double quotes around help? Jay Blanchard wrote: > [snip] > Don't do it in the header, but in the field itself just put a ' before > the first character and excel will interpret it as a text field. > [/snip] > > Tried that, the ' shows up. Don't want that to happen > --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004