If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'SUM' isn't working - what would cause this ?
This is a little strange. I have exported data from one of our applications
into Excel. I'm trying to total a range of numbers but it's just giving me '0'. I've formated the number cells to be 'numbers' and I've made sure the cell i'm putting the 'SUM' formula in is formatted as 'general'. but it's still not working. Anyone know what else I could try ? There has to be something simple I'm overlooking. Thank in advance ! |
#2
|
|||
|
|||
'SUM' isn't working - what would cause this ?
Those numbers you have exported/imported could still be text -
changing the format (of the cell) will not change their value. A quick way to change them is to highlight the numbers then click on Data | Text-to-columns and then click Finish on the first panel. Hope this helps. Pete On Sep 18, 11:46*pm, scott wrote: This is a little strange. *I have exported data from one of our applications into Excel. *I'm trying to total a range of numbers but it's just giving me '0'. I've formated the number cells to be 'numbers' and I've made sure the cell i'm putting the 'SUM' formula in is formatted as 'general'. *but it's still not working. *Anyone know what else I could try ? * There has to be something simple I'm overlooking. *Thank in advance ! |
#3
|
|||
|
|||
'SUM' isn't working - what would cause this ?
Unfortunately, that didn't work. ...thanks for trying though.
"Pete_UK" wrote: Those numbers you have exported/imported could still be text - changing the format (of the cell) will not change their value. A quick way to change them is to highlight the numbers then click on Data | Text-to-columns and then click Finish on the first panel. Hope this helps. Pete On Sep 18, 11:46 pm, scott wrote: This is a little strange. I have exported data from one of our applications into Excel. I'm trying to total a range of numbers but it's just giving me '0'. I've formated the number cells to be 'numbers' and I've made sure the cell i'm putting the 'SUM' formula in is formatted as 'general'. but it's still not working. Anyone know what else I could try ? There has to be something simple I'm overlooking. Thank in advance ! |
#4
|
|||
|
|||
'SUM' isn't working - what would cause this ?
Well, I found a work-around to export the data into a new spreadsheet, it
seems to be behaving now. The web-app must have done something to mess with the data on the previous attempts. "scott" wrote: Unfortunately, that didn't work. ...thanks for trying though. "Pete_UK" wrote: Those numbers you have exported/imported could still be text - changing the format (of the cell) will not change their value. A quick way to change them is to highlight the numbers then click on Data | Text-to-columns and then click Finish on the first panel. Hope this helps. Pete On Sep 18, 11:46 pm, scott wrote: This is a little strange. I have exported data from one of our applications into Excel. I'm trying to total a range of numbers but it's just giving me '0'. I've formated the number cells to be 'numbers' and I've made sure the cell i'm putting the 'SUM' formula in is formatted as 'general'. but it's still not working. Anyone know what else I could try ? There has to be something simple I'm overlooking. Thank in advance ! |
#5
|
|||
|
|||
'SUM' isn't working - what would cause this ?
Okay, well I'm glad you found a way to get it to work.
Pete On Sep 19, 12:37*am, scott wrote: Well, I found a work-around to export the data into a new spreadsheet, it seems to be behaving now. *The web-app must have done something to mess with the data on the previous attempts. "scott" wrote: Unfortunately, that didn't work. *...thanks for trying though. |
#6
|
|||
|
|||
'SUM' isn't working - what would cause this ?
Pete_UK wrote...
Those numbers you have exported/imported could still be text - changing the format (of the cell) will not change their value. A quick way to change them is to highlight the numbers then click on Data | Text-to-columns and then click Finish on the first panel. .... If the source data comes from HTML tables, it likely includes nonbreaking spaces. Text to Columns doesn't remove nonbreaking spaces. |
Thread Tools | |
Display Modes | |
|
|