Hello Dwight, To change the format of a cell to a number without a decimal point you can use CTRL+Shift+Tilde. You might need to use the JAWS pass through command first, which is the JAWS key with the number 3. (Use the number three that is above the E and not the one on the number pad). Try it without the pass through first but my system must be using that keystroke for something else and I need to use the pass through command. To change the format of a cell to a number format that uses two decimal places, a thousand separator and a minus sign when applicable use CTRL+Shift+! (that is the control key with the shift key and the number 1)
If you need to select a range to apply the formatting to then you can use CTRL+G and type in the first and last cell to be included in the range separated by a colon. For example, A7:g12 will select cells starting with a7 and ending with g12 once you press the enter key. You can then use the keystroke to apply the number format you want. If you want a different numbering format then use CTRL+1 and use the formatting dialog box to make your change. Take care. Brian Lee [email protected] -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Dwight Johnson Sent: Wednesday, February 11, 2015 6:38 AM To: [email protected] Subject: Re: [JAWS-Users] problem with excel Using excel 2007, windows 8.1 and jaws 14 this began on Monday. I put a value such as 200 in a cell but jaws says 4 jan or some other date bbut the total at bottom of the column is correct. -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of John Justice Sent: Tuesday, February 10, 2015 9:51 AM To: [email protected] Subject: Re: [JAWS-Users] problem with excel Jaws can be set to read the cells in many ways. There are specific settings in the Quick Settings section. 1. While focused on Excel, press INSERT+V to open the Quick Settings dialog. 2. Arrow down to the beginning of the texdt or use the Search window and type something like "read cell contents". 3. The easiest way is to press the letter T twice. That takes you to a setting indicating that Jaws should read the cell contents. 4. Now use first letter navigation C, pressed twice. 5. You will be in the settings for cells. Here's the great part of Quick Settings. If you aren't sure, just highlight a setting, then tab over and there will be a text box explaining what each setting does. The text explanations change, depending on which parameter you have highlighted currently. Before doing anything, look through these. 6. You can try a change, make a note of it and then if you don't like the results, open up Quick Settings again and try another setting. Excel settings for Jaws are quite extensive. I suggest you figure out what you want to do and then try to find the setting that makes Jaws do that. Reading cell contents is one of those settings. You can also have Jaws read the column or row settings in Excel but that's for another message. JOHN AND LINDA JUSTICE PERSONAL E-MAIL: [email protected] -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Mike Boyd Sent: Tuesday, February 10, 2015 1:41 AM To: [email protected] Subject: Re: [JAWS-Users] problem with excel Could you please elaborate a little on "Excel does not read the cells properly if at all"? If JAWS does read something, what does it say? It could be that the excel window needs to be maximized is all. Mike [email protected] -----Original Message----- From: Flor Lynch Sent: Monday, February 09, 2015 6:13 PM To: [email protected] Subject: Re: [JAWS-Users] problem with excel Which version of Excel do you have installed? -----Original Message----- From: Eyþór Kamban Þrastarson Sent: Monday, February 09, 2015 11:53 PM To: [email protected] Subject: [JAWS-Users] problem with excel Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor 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/ --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com 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/
