Adding Columns/Negative nums
Posted by Marc Smith on November 11, 2000 10:35 AM
I'm trying to organize a spreadsheet to keep a track of my stocks. I want it to look neat so put information in "every other" column to space things out. Well when I try to add numbers like 22.78, 31.90, 9.01, etc. with empty columns between them, it won't add. And then when I put in a number underneath those that are the same like 3.47 and so on it won't add them, it says I should enter decimals or integers....aren't those decimals between them? What's the problem there...can I not add numbers such as those?
And second...I tried to enter a negative number in a cell...like -2.50 and instead it put "Feb50" in the cell. I don't want to add those numbers, just put them in there for viewing purposes. Why can't I do that?
I'd really appreciate your help on this so I can get started. Thanks a lot.