Hi Vikas, The method explained will solve the problem in part only. E.g. if the number is 23.477, the format option will have it displayed as 23.48, but in all calculations it will be used as before. To round the number as 23.48 use the following method: Suppose the given number is in cell A1, and you want the rounded value in cell b1. Type the following in cell B1: =round(a1) and press enter. To round the marks of entire class displayed in cells a1 to a50, just copy the contents of cell B1 and paste in cells b2 to b50. Thanks, Anil
----- Original Message ----- From: "sameer latey" <[EMAIL PROTECTED]> To: <[email protected]> Sent: 08 July, 2006 5:50 PM Subject: Re: [AI] EXCEL QUERY > > Try the following steps and see if they solve your > problem. > > 1. In Excel, place your focus on the cell for which > you want to restrict the result. > 2. Press Ctrl+1 to open the Cell Format dialog. This > same dialog can also be accessed from the Format menu. > 3. Tab to the list box containing the various choices > like General, Currency, time, date etc. Arrow down to > Number and tab to the sub options. > 4. You will find an Edit box where you can specify the > number of decimal places. Set this to 2 and tab over > to OK and press it. > > The result will now be restricted to 2 decimal places. > You can do this for an entire row/ column by selecting > the entire row/ column and repeating the above steps. > > Regards > Sameer > --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > > > Dear Members, > > I know here on this list there are many excel > > specialists. Though I don't have any mastery over > > excel, I use this application for a very limited > > purposes like preparing the internal assessment for > > my college students and I find it very useful for > > this purpose. I just wanted to know one very minute > > clarification, that is, how do we restrict the > > formula results to only two digits after dot. > > Suppose, after some calculations, if the result > > displayed is, 75.318654, how can we restrict to only > > two digits, that is, 75.32. My sighted friends do > > this just at a click of one mouse command, but when > > I try to access the same with the jaws, or pc > > cursor, it is not visible. > > Regards, > > Vikas Kapoor, > > MSN ID: > > [EMAIL PROTECTED] > > Yahoo ID: > > [EMAIL PROTECTED] > > Skype ID: dl_vikas > > Mobile: (+91) 9891098137. > > To unsubscribe send a message to > > [EMAIL PROTECTED] with the > > subject unsubscribe. > > > > To change your subscription to digest mode or make > > any other changes, please visit the list home page > > at > > > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.9.10/383 - Release Date: 07-07-06 > > To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
