Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I don't think auto complete has anything to do with this, more likely either
calculation was set to manual under toolsoptionscalculation or the values are/were text -- Regards, Peo Sjoblom "Jannie" wrote in message ... I figured it out. Tools, Option, Edit Enable, Auto Complete - needed disabled. Thanks. "Jannie" wrote: Please explain what that is - set to automatic?? "Don Guillett" wrote: Please do NOT type in all caps and please don't ask for a fast answer. All questions get equal billing. And, please fully describe your problem with examples. Could it be that you have calculation set to automatic? -- Don Guillett Microsoft MVP Excel SalesAid Software "Jannie" wrote in message ... This worksheet has 5 columns of numbers when the columns are added =sum formula to add down it always returns on a 1 as the sum total and not add the entire column. What is it doing and how do I fix it. Is it something global. Jannie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Question, But No Answer | Excel Worksheet Functions | |||
Question about hyperlink, need help FAST! | Excel Discussion (Misc queries) | |||
search string command to answer simple Yes or No | Excel Worksheet Functions | |||
There may be a simple answer ... | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |