Hi again Scott, In my Excel 2013 the CTRL+Tilde key changes to the number format as mentioned in my last message. I just checked a list of keystrokes for Excel 2007 and it showed CTRL+Shift+Tilde key. If the CTRL+Tilde doesn't work after selecting a cell with the date format then try the CTRL+Shift+Tilde.
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/
