SalientAnimal Posted September 6, 2012 Share Posted September 6, 2012 Hi All, My quest is pretty simple, but I haven't been able to find a solution. I'm trying to extract a BIGINT value of 13 characters with my query. Everytime this number is exported to Excel in CSV from MySQL Workbench the number is not displayde correctly in the cells and you first need to format the cell. Is there a way to run the query so that the conversion happens before exporting to Excel CSV? Link to comment https://forums.phpfreaks.com/topic/268061-convert-bigint-to-view-in-excel/ Share on other sites More sharing options...
Pikachu2000 Posted September 6, 2012 Share Posted September 6, 2012 So what conversion happens first? Link to comment https://forums.phpfreaks.com/topic/268061-convert-bigint-to-view-in-excel/#findComment-1375727 Share on other sites More sharing options...
Jessica Posted September 6, 2012 Share Posted September 6, 2012 This is a problem with Excel, you're talking about the number being shown in scientific notation, right? The only trick I've found is to make sure it's a string, by putting quotes around it. Quotes in the output. Link to comment https://forums.phpfreaks.com/topic/268061-convert-bigint-to-view-in-excel/#findComment-1375767 Share on other sites More sharing options...
SalientAnimal Posted September 7, 2012 Author Share Posted September 7, 2012 Thanks guys, I managed to solve this by using a CONCAT(FIELD,"\t"). Link to comment https://forums.phpfreaks.com/topic/268061-convert-bigint-to-view-in-excel/#findComment-1375986 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.