Display numbers in Lakhs

Hi,

In Excel I needs to convert numbers in to indian format and the value should divided by lakhs and display in Lakhs.

Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian format)

Plz help.

Regards,

Prabhu



https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Hi Prabhu,

Try

="Rs."&TEXT(--MID(A2,4,20)/100000,"#,##0.00")