Re: Re: excel output question
| From: | Jake McHenry | Date: | Sat, 07 Feb 2004 07:30:13 +0000 |
| Subject: | Re: Re: excel output question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-177085@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: "Paul Furman" <paul@edgehill.net>
To: <php-general@lists.php.net>
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