How to convert into Lacs ( ie.100000)

[ramakrishnan_1731]

Dear Experts,

In a work sheet i have a colum of numbers. I want to convert these into lacs ( divide by 100000 ). Now i am inserting one column next to the column of numbers and using foumula = a1/100000 copy these till the end of the colum the copy paste special and values.

Is there any other methord with out inserting a coulmm.

 

[Domski]

Hi,

Enter 100000 in a spare cell, copy it, select the column of numbers and then paste special with the divide option selected.

Dom

 

[ramakrishnan_1731]

Thanks

Dear Domski,

Thanks. Its working.

Regds
Ramakrishnan

 

[tusharm]

I would recommend that you do *not* replace the original data. Use the 2nd column to compute the numbers in lacs and then use this 2nd column for further analysis. This provides an easy to follow audit trail of the process.

Dear Experts,

In a work sheet i have a colum of numbers. I want to convert these into lacs ( divide by 100000 ). Now i am inserting one column next to the column of numbers and using foumula = a1/100000 copy these till the end of the colum the copy paste special and values.

Is there any other methord with out inserting a coulmm.

 

[Boller]

Format as :- #\.00000

Or perhaps :- #\,00000

If you need full Indian currency formatting then :

For numbers up to 9 digits (and 2 decimal places), format the cells as follows ;-

[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

If your numbers are likely to exceed 9 digits, amend the format accordingly.

To save typing the format to start with, select a cell and run this :-

Selection.NumberFormat = "[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00"

The number format should now be in your custom format listing.

 

[twelveheads]

Hi, Would you know how to modify this formula to include larger numbers such as 1892,23,13,258.26 and negative numbers such as -1,241,657,500.00 - all in one.