Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
How do I 'SUM' a column corrected to 2 decimal places from 3 | Excel Discussion (Misc queries) | |||
how to put 'SUM' formula in VB after picking up certain names and their bonus | Excel Discussion (Misc queries) | |||
'SUM' Tables | Excel Worksheet Functions |