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.

--- "PravinT" wrote:
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.