Need Macros

[PravinT]

I want to convert figures in Rupees in to Rs. in lakhs, for example
Rs. 10,73,000.00 to be converted to / replaced with 10.73.
If any one knows any macros or custom formats then please help me.

Thanks with regards
Pravin Thorat

 

[Bob Bridges]

I had the impression that a lakh is simply a thousand, Pravin. Is that
wrong? Anyway, you can have 1,000,000 display as 1,000 without changing the
value in the cell by using the custom format "0,"; that tells Excel to drop
the last three digits, so that it's displayed in thousands. You can display
it in millions by using "0,,", and so on. If you use spaces between
thousands, instead of commas (as I do), use a space in the format code.

 

[Sane]

I had the impression that a lakh is simply a thousand, Pravin.  Is that
wrong?  Anyway, you can have 1,000,000 display as 1,000 without changing the
value in the cell by using the custom format "0,"; that tells Excel to drop
the last three digits, so that it's displayed in thousands.  You can display
it in millions by using "0,,", and so on.  If you use spaces between
thousands, instead of commas (as I do), use a space in the format code.





- Show quoted text -

This may help you
Considering 1073000 is in A1, enter formula in B1 =ROUND(A1/100000,2)