I tried copying the numbers and doing a "paste special" as a "value", but strangely that actually seemed to make the numbers text (lined up on the left - where the original ones lined up on the right). I tried formatting the numbers as text in the cell formatting section. Then I filled across and it worked great for the next two columns, but the last returned "zero" as an answer. I created the formula for one column and it worked great. I am having problems with a basic sum formula. A few things have tripped me up here, and I'm hoping there's some magic button I haven't found yet to fix my problem. I have been using the sum function for a very long time, but just recently got a new computer and the "new" Excel 2007.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |