Re: CSV output.
| From: | Stephen Johnson | Date: | Mon, 08 Sep 2008 20:57:53 +0000 |
| Subject: | Re: CSV output. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-279696@lists.php.net to get a copy of this message | ||
It sounds like you simply need to number format the data to ensure that PHP
does not truncate
http://php.net/number_format
If excel, or whatever your using to view the csv file, is truncating then
you will need to properly format that cell.
--
Stephen Johnson c | eh
The Lone Coder
http://www.thelonecoder.com
continuing the struggle against bad code
http://www.fortheloveofgeeks.com
I¹m a geek and I¹m OK!
--
> From: Tom Shaw <php.coder@tx.rr.com>
> Date: Mon, 8 Sep 2008 15:53:58 -0500
> To: PHP list - not junk <php-general@lists.php.net>
> Subject: [PHP] CSV output.
>
> I'm outputting a bunch of numerical values for a spreadsheet to calculate
> total sales among other things on a client shopping cart. I'm running into
> problems with values that contain zeros after the decimal. If a value is
> 234.55 the value outputs fine to the CSV file but if the value is 234.00
> only 234 shows up. Is there any way to force the zeros into the spreadsheet?
>
>
>
>
> Thanks
>
>
>
> Tom Shaw
>
> php.coder@tx.rr.com
>