Search This Blog

Search Engine

Custom Search

20081230

How to get the Numeric Currency in Indian Rupees in Excel? Means how to get commas for a number in lacs & crores instead of for millions and billions?

How to get Numeric Currency from billions & millions to lacs & crores in Excel?


Right click cell.
Go to Format Menu
In Category click Text
Then Click Custom

Then paste this below 2 codes and u will be getting nos. in lacs

Without decimal : 
99,99,99,999 [>=10000000]#","##","##","###;[>=100000]#","##","###;#,###

With decimal : 
99,99,99,999.00 [>=10000000]#","##","##","##0.00;[>=100000]#","##","##0.00;#,##0.00

And now you get amounts in Indian currency format.

Thx
XYZ

20081229

How to activate conference call in Airtel?

Call Conference activation procedure-AIRTEL





SMS - ACCF to 511

Call conference will be activated in 4 hours

Monthly rent Rs. 49/-

-------------------------------------------------

Now,

How to join 2 calls on cell phone once this service gets activated

In Mobile (eg. Nokia 3700)

Click Menu

Go to Settings

Go to Call Settings


Click on/Press Call Waiting Service

Click Activate

Click Back

Come out by pressing C on mobile

Then Call No. 1

Put call on Hold

Dial No. 2

Press Options

"CONFERENCE" Wording will be seen

Press Conference

Both calls will be connected