Convert amount or group of amounts to lacs or thousand

[gskelkar]

Dear Sir, I am preparing balance sheet every year, while submittion to income tax, i need to convert all amounts to lacs or thousand, so i want to ask can we prepare a code which will convert selected amounts to lacs or thousand,

 

[pecoflyer]

Please post a sample sheet ( no pics) with some data and eventually mocked-up desired results. thx

 

[bosco_yip]

Convert amount to lacs or thousand​

Maybe something like this:

1] In A2, enter your amount

2] In B2, enter formula:

=FILTERXML(WEBSERVICE("https://excelkida.com/xml/amount-to-word?style=ind&lang=en&num="&A2),"/data")