Hi
You mean like this..
in J2 and copied down,
="Rs. "&ROUND(I2/100000,2)&" Lakhs"
Hi
You mean like this..
in J2 and copied down,
="Rs. "&ROUND(I2/100000,2)&" Lakhs"
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Hi,
Yes, i want to devid all the numbers by(100000) but is there any way to use macro for all the numbers in the paget to convert in to lakhs.
Plz find the attached sheet whare i want to convert all the numbers value in to lakhs.
regerds,
Prabhu
Posting Permissions
Reply With Quote
Bookmarks