----- Original Message ----- From: "Paul Furman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 07, 2004 1:56 AM Subject: [PHP] Re: excel output question
> Single quote everything should work. > > Jake McHenry wrote: > > > Hi everyone. I'm outputing payroll information to an excel csv file, and when anyone get's paid over 1k, the amount is split into two fields because of the comma in the amount. Is there anyway I can tell excel that this particular comma is not a deliminator? > > > > Thanks, > > Jake > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > like this? output = "'$fullname',,'$location',,'$regularhours','$vachours','$sickhours','$compho urs','$mischours','$wopyhours','$sefahours','$biweekly[0]','$adjustedtime',, ,,,'$sub401k ','$payrate','$gross5'\n"; That just filled my spreadshit with quotes around everything... still the amounts larger than 1k are in 2 columns...... did I do something wrong? Thanks, Jake -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
