[AI] Round off in MS Excel
syed.fame at gmail.com
Wed Aug 8 01:01:01 EDT 2007
----- Original Message -----
From: "Abdul Razique Khan" <1988.abdul at gmail.com>
To: <accessindia at accessindia.org.in>
Sent: Tuesday, August 07, 2007 8:02 AM
Subject: Re: [AI] Round off in MS Excel
> Hello my dear friends,
> You'll have helped me out in a problem which I thought had no
> solution. I have got the solution with everybodies help. If anybody
> faces this problem follow the following solution.
> For instance if you want 1.87 to be rounded off with two decimal
> places which will be 2.00.
> Step1. Type =round(1.87,0).
> Step2. Press Control+1 to go to the format cells dialogue box and in
> the number tab, select the number option with 2 decimal places.
> This will yield the result you want.
> To unsubscribe send a message to accessindia-request at accessindia.org.in
> with the subject unsubscribe.
> To change your subscription to digest mode or make any other changes,
> please visit the list home page at
More information about the AccessIndia