you could always try to re-format the cells in excel (right click, format cells, then under the "number" tab, select number or currency). might work, but I feel like these are hoops you shouldn't need to jump through. at least I've never had to....
Printable View
you could always try to re-format the cells in excel (right click, format cells, then under the "number" tab, select number or currency). might work, but I feel like these are hoops you shouldn't need to jump through. at least I've never had to....
No you misunderstand, the problem is when i export it to CSV, not CSV for MS Excel
Instead of using phpMyAdmin, why not try Sales Report (in the Plugins at the top of the page). It does date based reporting and should give you what you need.