Hi, You need to use the ground function. If I remember correctly, the syntax is as follows. =round(number to be rounded,decimal places)
Pranav -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Abdul Razique Khan Sent: Monday, August 06, 2007 9:30 PM To: [email protected] Subject: [AI] Round off in MS Excel Hello Friends, I want to round off a number in MS Excel but I also want two decimal places after that which will obviously be .00. For example- 1884.46 should become 1884.00 whereas 1884.70 should become 1885.00. I want this to be done automatically as I am preparing a lenghthy calculation. Please help me, its urgent. Expecting a solution. 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
