⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Export to excel varchar problems with numbers

Started by joe63, 24 March 2015 - 15:09 PM


joe63

joe63
  • profile picture
  • Member

Posted 24 March 2015 - 15:09 PM

Hi

 

I have a problem when exporting data to excel.

 

In the database it is declared  as varchar

 

db -- >

  telephone varchar(50) utf8_general_ci

 

the cell J2 in Excel display the number 633723754

but in the table I got the following display

 

6,34E+08

 

This happens not on every number but I can not see a pattern

 

Thanks in advance

//Joe63


Franco Quijano

Franco Quijano
  • profile picture
  • Member

Posted 21 January 2016 - 15:19 PM

Any solutions? same problem here....


xmyownprisonx

xmyownprisonx
  • profile picture
  • Member

Posted 21 January 2016 - 23:24 PM

I think you just need to expand the excel format that fits to the number of character. if you decalre it as varchar it will remain as is.