Hello, The formula is =round(value, NumberOfDecimalPlaces) For instance, =round(1.23,2) yields 1.00 and =round(1.89,2) yields 2.00.
After all, it has to be put in a formula. When you put a value in the cell, it does not automatically convert the value into founded numbers. However, you can always apply this formula in a result cell. Say you are putting the sum of A1:A5 in cell A6. In that case, you can enter this formula in cell A6: =round(sum(a1:a5),2) Best regards, Amiyo. Cell: +91-9433464329 ----- Original Message ----- From: "Abdul Razique Khan" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 07, 2007 11:36 AM Subject: Re: [AI] Round off in MS Excel > Hello Sir, > Can you show an example. Its very urgent. > Thanks > Abdul > > 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 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
