sukhman4 Posted August 20, 2007 Share Posted August 20, 2007 Hii.. I have a table in mysql wich contain a sim_number field which is 19 digit unsigned number. i have designed a script using php headear command for exporting data as excel. It is working but with the follwoing problem. Since sim_number is 19 digit number when it get exported as .xls file. now when that .xls file is opened, excel automatically detect this sim_number as number and , since excel can store only 15 digit in number format it converts its last 4 digits to zeros. Is there any way to get this sim_number exported as text so that excel store complete 19 digit number in text format. P.S I cannot attach some charctor to this sim_number because of restricion on file format. Please help..Thanx Quote Link to comment https://forums.phpfreaks.com/topic/65780-problem-in-exporting-data-from-mysql-using-php-in-excel-form/ Share on other sites More sharing options...
vijayfreaks Posted August 20, 2007 Share Posted August 20, 2007 Hi.. try to convert it into string and then pass for .xls processing.. Regards, Vijay Quote Link to comment https://forums.phpfreaks.com/topic/65780-problem-in-exporting-data-from-mysql-using-php-in-excel-form/#findComment-328629 Share on other sites More sharing options...
sukhman4 Posted August 20, 2007 Author Share Posted August 20, 2007 can u eleborate please.. Quote Link to comment https://forums.phpfreaks.com/topic/65780-problem-in-exporting-data-from-mysql-using-php-in-excel-form/#findComment-328635 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.