thanks.
On 29 November 2011 11:05, Ankit Agrawal wrote:
> Hi Aamir,
>
>
>1. Click the *Microsoft Office Button* [image: Button image], click *Excel
>Options*, and then click *Add-Ins*.
>2. View the add-ins and application extensions that are categorized as
>follows:
> - *Ac
Hi Aamir,
1. Click the *Microsoft Office Button* [image: Button image], click *Excel
Options*, and then click *Add-Ins*.
2. View the add-ins and application extensions that are categorized as
follows:
- *Active Application Add-ins* Lists the extensions that are
registe
how to recall this add-inn in working sheet.
Regards,
Aamir Shahzad
On Mon, Nov 28, 2011 at 11:41 AM, Ankit Agrawal
wrote:
> Hi Harsh,
>
> Use attached add-inn.
>
> Regards,
> Ankit
>
>
> On Mon, Nov 28, 2011 at 1:22 AM, Vinod Narayanan wrote:
>
>> Hi Harsh,
>>
>>
>> Select the cells which requ
Hi Harsh,
Select the cells which requires the formatting to be done and in Format
Cells --> Custom, Please type *#,* to convert numbers in thousands and so
on
Option 1 = If base data is 10 - type *#,* in Format Cells -->
Custom.. The result will be 100
Option 2 = If base data is 100
You can make use of the copy and paste special option where you use
the multiply option. Just type 1000 in a cell, copy it, and paste
special values after selecting all cells that you want to change to
thousands by selecting the multiply option.
Sam
On 27/11/2011, ashish koul wrote:
> Try this
>
Try this
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
On Sun, Nov 27, 2011 at 10:00 AM, harsh shah wrote:
> dear all,
>
> i have a data sheet with numbers in it.
>
> i want to convert them into thousands or in lacs.
>
> is there a way to format the select
