Hi Scott, It sounds like the cells are formatted for dates. Select the cells and try using CTRL with the tilde key. (the key above the tab key). This should change the cell contents to numbers. Otherwise, after selecting the cells use CTRL+F1 and pick the correct type of formatting for the cells.
Take care. Brian Lee [email protected] -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Scott Meyer Sent: Saturday, March 1, 2014 5:32 PM To: [email protected] Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula Hi Brian no go , cell says 1-0-1900 the next cell down says 1-1-1900 tried both ways you suggested. the second question was solved by doing a =m2 . it is a mystery Thanks Scott -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Brian Lee Sent: Saturday, March 01, 2014 7:24 PM To: [email protected] Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula Hello Scott, Use the formula =sum(h2,k2,l2) There should be no spacing in the formula. You had a space after h2. A comma follows h2 and k2 but not l2. No plus signs are used in that formula. You could also just type =h2+k2+l2 again without using the word sum and with no spacing and no parentheses or commas just a plus sign between h2 and k2 and another one between k2 and l2. I am not sure what you mean with the second part of your question. You can copy the content of a cell with CTRL+C and paste it in another empty cell. I don't think that is what you are meaning though. Take care. Brian Lee [email protected] -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Scott Meyer Sent: Saturday, March 1, 2014 1:12 PM To: [email protected] Subject: [JAWS-Users] 2007 Microsoft Excel Questions about formula Hi trying to add 3 colums put in =Sum(H2 +k2+L2) and I get #value in cell also want to put a number that is in a colum in another colum put =Sum(M2)That just showed the formula.What am I doing wrong? regards Scott For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
