| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using sum on a column I am getting ### instead of a total
Hi when adding up a colum using sum instead of getting the total I am getting
### I can see the correct answer bottom right as usual but when I try to enter the total myself it revertts back to ### How do I get round this please? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using sum on a column I am getting ### instead of a total
That symbol normally appears if the column is not wide enough.
try widening your column where the total is. Matt vladtheimpaler wrote: Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter the total myself it revertts back to ### How do I get round this please? -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200806/1 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using sum on a column I am getting ### instead of a total
Hi there Markv here
Widen your cells from the top this problem occurs when the cells are too narrow to display the result. "Mattlynn via OfficeKB.com" wrote: That symbol normally appears if the column is not wide enough. try widening your column where the total is. Matt vladtheimpaler wrote: Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter the total myself it revertts back to ### How do I get round this please? -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200806/1 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using sum on a column I am getting ### instead of a total
"vladtheimpaler" wrote: Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter the total myself it revertts back to ### How do I get round this please? Thank you unfortunately it didn't quite work . what it did was insert the last figure to be added! Any ideas? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using sum on a column I am getting ### instead of a total
"vladtheimpaler" wrote: Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter the total myself it revertts back to ### How do I get round this please? i closed the file and did not save the changes and then widened the column.EUREKA!!! It worked I was able to type the right figure in. Thanks to all who replied. Vladtheimpaler |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using sum on a column I am getting ### instead of a total
"Mattlynn via OfficeKB.com" wrote: That symbol normally appears if the column is not wide enough. try widening your column where the total is. Matt Thanks problem now solved! Vlad vladtheimpaler wrote: Hi when adding up a colum using sum instead of getting the total I am getting ### I can see the correct answer bottom right as usual but when I try to enter the total myself it revertts back to ### How do I get round this please? -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200806/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| disable Total and/or Sub total for a single column | Excel Worksheet Functions | |||
| XL formula - total of row = total of column | Excel Worksheet Functions | |||
Linear Mode
