Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Sum for database data
I have a sql query that imports data from a MySQL database.
When the data is brought into Excel I can't sum the numbers. |
#2
|
|||
|
|||
Without all of the details, I'm guessing that the SUM equates to zero.
If that is true, the values may be text that appear to be numbers. Try this to correct the problem: 1)Put a 1 in a blank cell and select that cell 2)EditCopy 3)Select the imported values 4)EditPaste Special --Select Multiply --Select Values Click the [OK] button. Does that resolve the problem? -- Regards, Ron "jnorton" wrote: I have a sql query that imports data from a MySQL database. When the data is brought into Excel I can't sum the numbers. |
#3
|
|||
|
|||
Thanks, I found that to work but I also realized that it is better to change
the structure of table in the MySql database. I used decimal instead of varchar. jn "Ron Coderre" wrote: Without all of the details, I'm guessing that the SUM equates to zero. If that is true, the values may be text that appear to be numbers. Try this to correct the problem: 1)Put a 1 in a blank cell and select that cell 2)EditCopy 3)Select the imported values 4)EditPaste Special --Select Multiply --Select Values Click the [OK] button. Does that resolve the problem? -- Regards, Ron "jnorton" wrote: I have a sql query that imports data from a MySQL database. When the data is brought into Excel I can't sum the numbers. |
#4
|
|||
|
|||
I have a similar problem - MySQL returns the field type 'decimal' and Excel
2003 does not recognise it as numbers!. I obviously can create a column with a formula "=Value(TheCellWithTheDecimalNumber)" - but I want to analyse the data with a pivot table directly. Any hints? Rainer "jnorton" wrote: Thanks, I found that to work but I also realized that it is better to change the structure of table in the MySql database. I used decimal instead of varchar. jn "Ron Coderre" wrote: Without all of the details, I'm guessing that the SUM equates to zero. If that is true, the values may be text that appear to be numbers. Try this to correct the problem: 1)Put a 1 in a blank cell and select that cell 2)EditCopy 3)Select the imported values 4)EditPaste Special --Select Multiply --Select Values Click the [OK] button. Does that resolve the problem? -- Regards, Ron "jnorton" wrote: I have a sql query that imports data from a MySQL database. When the data is brought into Excel I can't sum the numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Source Name Not Found | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |