: Formats a standard number into the Indian style comma-separated currency format (Lakhs and Crores), such as transforming "100000" into "1,00,000". =REVINR(cell_reference)
It appears to have been a small, community-driven tool rather than an official Microsoft product. The blog's language, a mix of English and Tamil, suggests it was created for a local audience of Tamil-speaking Excel users.
Click , select the SureshAddin.xla file, and ensure it is checked in the list. Modern Alternatives
' Code for ThisWorkbook or a Module to handle menus Const MenuName As String = "Suresh Utilities" Sureshaddin.xla
It triggers security alerts from Windows Defender or your antivirus software.
Converts a standard number into an Indian comma-separated string format. 5023500 "50,23,500"
The file is often mentioned alongside a blog and was reportedly hosted on third-party file-sharing services like Box.com. : Formats a standard number into the Indian
Open the File Explorer and copy the file into the following system directory (replacing [YourUsername] with your actual system profile name): C:\Users\[YourUsername]\AppData\Roaming\Microsoft\AddIns\
To configure Sureshaddin.xla , follow these sequential steps:
is a specialized Microsoft Excel add-in designed primarily for users in India to manage currency formatting and convert numbers into words following the Indian numbering system (Lakhs and Crores) . Unlike standard Western formats that use millions and billions, this tool provides functions to automate the specific stylistic requirements of Indian financial reporting. Key Functions of Sureshaddin.xla Click , select the SureshAddin
It yields cleanly structured dashboards optimized for regional fiscal audits. However, because the resulting string is converted into a Text Format , standard background math formulas cannot use this output directly without triggering calculation errors. 3. =REVINR(cell_reference)
This function takes a number and formats it with commas in the Indian style. =INR(1000000) → 10,00,000 3. REVINR() - Reverse the INR Function
The file is a lightweight, classic Excel tool designed to solve this exact problem by automating the "Numbers to Words" conversion specifically for the Indian numbering system. Why Use SureshAddin?
The naming is a dead giveaway of a . Somebody named Suresh (likely an analyst, accountant, or small business owner) created this add-in to speed up their daily workflow. Over time, the file got shared via email or network drive and became a quiet dependency for several spreadsheets.
Press Win + R , paste the following path, and press Enter to open your local AddIns folder: %appdata%\Microsoft\AddIns Cut and paste Sureshaddin.xla directly into this directory. Step 2: Activate the Tool via Excel Options