On Jan 22, 11:00*am, Bob Bridges
wrote:
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.- Hide quoted text -

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