 |
 |
To remove decimal values from numbers * Highlight the cell which contains the value for which you want the integer portion. * The data in the formula bar should be edited to read =INT(data). * For example, if the cell contains the formula =A4*E2, you would change it to =INT(A4*E2). Above from http://learning.mccombs.utexas.edu/tutorials/ExcelforMBA.doc To centre text in a cell, I simply created a Macro. George. ________________________________ From: Discussion list for disabled students and their support staff. [mailto:[log in to unmask]] On Behalf Of Jonathon WHITE Sent: 20 December 2004 13:23 To: [log in to unmask] Subject: Microsoft Excel 2002 - keyboard shortcuts I am looking for answers to the two questions below in relation to Microsoft Excel 2002. Any responses would be gratefully received. 1. What is the keyboard shortcut in Excel to format numeric data to Integer? 2. What is the keyboard shortcut in Excel to right align text. (Ctrl + R does not work for the alignment here, it merely replicates the previous cell). Please note. I have already used the resources below without success: - Microsoft Support Knowledge Base: http://support.microsoft.com/default.aspx?scid=fh;en-us;KBHO WTO - Microsoft Accessibility: http://www.microsoft.com/enable - Microsoft Excel: using and designing: a training manual for blind and partially sighted computer users - by Julia Cox. RNIB, 2003. Many thanks Jonathan White Learner Services South Cheshire College Tel. 01270 654654 Ext. 204 This Message has been scanned for viruses by McAfee Groupshield.