Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have simple Sum Functions in my Worksheet and they are all correct.
In one of the Cells I only get a minus "-" sign. But the formula in the cell is correct! =Sum(A1:A12). When I check the formatting under Format Cells I see that the Format is "Accounting" but even if I change it back to Number or Custom it doesn't make a change. I can only fix it by copying another Sum Formula and paste it using Paste Special - Value. However, this starts to annoy me now. Why is this happening or what am I am doing wrong that I get those errors in my formulas? Any ideas? Nicole |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |