| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
when I try to total a row I only get an answer of #### why?
I had a file saved in excel and when I edit it and try to get a sum for a
cell, I only get an answer that looks like #####? Why and how can i change it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I try to total a row I only get an answer of #### why?
Widen the column--or change to a smaller font.
Hope wrote: I had a file saved in excel and when I edit it and try to get a sum for a cell, I only get an answer that looks like #####? Why and how can i change it? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I try to total a row I only get an answer of #### why?
First thing to check is column widths. Widen the column.
-- Cheers, Shane Devenshire "Hope" wrote: I had a file saved in excel and when I edit it and try to get a sum for a cell, I only get an answer that looks like #####? Why and how can i change it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| If total answer is over default of 160 then 160, otherwise the formula i have works great! | Excel Worksheet Functions | |||
| I put a Calc. in to get a total IE =K12 the answer comes up as 0 | Excel Discussion (Misc queries) | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
