Prev: How do I create a travel expense report by employee, by campus
Next: In Excel, changing a range of cells to all caps.
From: Ashish Mathur on 4 Apr 2010 22:38
Hi,

I know that. I was just giving an alternative

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:BNGdneY4Urab7yrWnZ2dnUVZ8vydnZ2d(a)bt.com...
> =ROUND(A3,-2) will do, and that doesn't need ATP.
> --
> David Biddulph
>
>
> "Ashish Mathur" <mathurashish(a)hotmail.com> wrote in message
> news:C8D64230-7FC0-4AFF-96A5-8D09C0F46714(a)microsoft.com...
>> Hi,
>>
>> You may also try =mround(A3,100). For Excel 2003 and prior versions, you
>> would have to install the Analysis Toolpak from Tools > Addins
>>
>> --
>> Regards,
>>
>> Ashish Mathur
>> Microsoft Excel MVP
>>
>> "Khaled" <khaledity(a)gmail.com> wrote in message
>> news:111534c6-68ef-4b1c-994d-e24cb1ccdd1d(a)e7g2000yqf.googlegroups.com...
>>> How can I round 980 to 1,000?
>>
>
First  |  Prev  | 
Pages: 1 2
Prev: How do I create a travel expense report by employee, by campus
Next: In Excel, changing a range of cells to all caps.