[AI] Round off in MS Excel

Syed Imran syed.fame at gmail.com
Wed Aug 8 01:01:01 EDT 2007


good good
----- 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.
>
> Thanks,
> Abdul
>
> 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
>  http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in 





More information about the AccessIndia mailing list