Hi Brian That did the trick. column was in date format . knew it had to be something easy if you knew what you were looking for, like you did. Scott
-----Original Message----- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Saturday, March 01, 2014 10:34 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula Also, it is not CTRL+F1 as I mistakenly typed. It is CTRL+1 that brings up the formatting dialog box. Take care. Brian Lee brianl...@charter.net -----Original Message----- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Saturday, March 1, 2014 7:15 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula Hello Scott, One more comment is that using CTRL+Shift+1 changes the cell formatting to the numbering format using two decimal places. Take care. Brian Lee brianl...@charter.net -----Original Message----- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Scott Meyer Sent: Saturday, March 1, 2014 5:32 PM To: jaws-users-list@jaws-users.com 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:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Saturday, March 01, 2014 7:24 PM To: jaws-users-list@jaws-users.com 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 brianl...@charter.net -----Original Message----- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Scott Meyer Sent: Saturday, March 1, 2014 1:12 PM To: jaws-users-list@jaws-users.com 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/ 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/