[AI] Round off in MS Excel
shivraheja at gmail.com
Tue Aug 7 09:10:33 EDT 2007
I think for that you can try to change the format of your cell. Try this,
press the application key and select the option "format cell...". Once the
dialog box is open, you must be in the number tab, if not then press control
+ tab to come to the number tab. Here, in the catigory list select number,
and tab and choose decimal places 2, then tab and press the okay button.
If you want to do this for the entire column then you can select the entire
column by using the keystroke "control + space bar" and then access the
format cell dialog box with the keystroke control + 1 on the num row.
Hope this helps.
----- Original Message -----
From: "Abdul Razique Khan" <1988.abdul at gmail.com>
To: <accessindia at accessindia.org.in>
Sent: Tuesday, August 07, 2007 4:01 PM
Subject: Re: [AI] Round off in MS Excel
> Hello Amiyo,
> I tried the formula posted by you. As per your formula =round(1.23,2)
> yields 1.00 but I'm getting 1.23 instead of 1.00. wwhen I tried
> =round(1.23,0) I'm getting 1. I want those two zeros after decimal. Is
> it possible, friends please help.
> 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