This is a problem I've been fighting against for years now. You used to be able to put a single quote at the front of text, and it would preserve the format. Excel doesn't do this anymore, so you always end up with a number. The only way to change is this is to apply custom formatting; FORMAT > CELL > NUMBER > NUMBER. You can either do this after the spreadsheet has loaded, or write out a real XLS spreadsheet from PHP with the formatting in it already. Search on 'phpclasses.org' for Excel writers. Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of tantan wijaya Sent: 05 November 2007 08:20 To: php-objects@xxxxxxxxxxxxxxx Subject: export MySQL - Excel Problem Dear All, I've problem about exporting my MySQL table to excel at some field with value (e.g 30320000400021 ) in MySQL table become like 3,032E+13 in CSV or excel. Can any one help me..i use script in header in file to export like this : header("Content-type: application/x-msdownload"); header("Content-Disposition: attachment; filename=data_agen_".date("d-m-Y_H_i").".xls"); header("Pragma: no-cache"); header("Expires: 0"); print $header."\n".$data; Or is there wrong in my table structur type ?! i use type int, varchar and text but same result occured.. :( Please some body help me.. Thanks _______________ *********************************************************************************** Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient or entity to whom they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Random House Group + 44 (0) 20 7840 8400 http://www.randomhouse.co.uk http://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.uk Generic email address - enquiries@xxxxxxxxxxxxxxxxx Name & Registered Office: THE RANDOM HOUSE GROUP LIMITED 20 VAUXHALL BRIDGE ROAD LONDON SW1V 2SA Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 ***********************************************************************************
