Sureshaddin.xla 'link' Online
: This is the most popular feature of the add-in. It automatically converts a numeric value (e.g., 100 ) into its English word equivalent (e.g., Rupees One Hundred Only ).
: Reverses the INR formatting, converting formatted currency strings back into standard numerical values suitable for further mathematical calculations. File Format & Compatibility extension denotes a legacy Excel Add-In file based on VBA (Visual Basic for Applications). Compatibility
For the safety of your personal data and system integrity, the recommended path is to . Instead, the safest and most reliable solution is to create your own VBA function using trusted, publicly available code from a professional community site. This approach provides the same functionality without the risk. Staying safe with add-ins is a matter of balancing convenience with caution, and in the case of Sureshaddin.xla, the balance weighs heavily against its use.
To use these custom functions, the add-in must be manually integrated into Excel: Sureshaddin.xla
: Converts a number into Indian Rupees in word format.
: Formats a number with Indian style commas (Lakhs and Crores) and returns it as text.
' 2. Sheet Protection Tools Set MenuItem = NewMenu.Controls.Add(Type:=msoControlPopup) MenuItem.Caption = "Protection Tools" : This is the most popular feature of the add-in
An .xla file is a legacy file format for used in versions prior to Excel 2007 (though still supported today). Unlike standard .xls or .xlsx workbooks, these files are hidden from view when opened; they run in the background to provide:
If you send an Excel file that contains =INR() formulas to a colleague who does have Sureshaddin.xla installed, they will see a #NAME? error. To avoid this, you can:
The add-in introduces three primary User Defined Functions (UDFs) that are not natively available in standard Excel versions: File Format & Compatibility extension denotes a legacy
Imagine you have a cell (e.g., A1) containing the number 125000 . In a financial document, this number often needs to be written in words, such as "One Lakh Twenty Five Thousand Rupees Only." A user of Sureshaddin.xla could enter a formula like =SureshConvert(A1) in another cell, and the add-in would automatically generate the textual version, saving significant time and reducing manual errors.
This lets users cleanly display information using the =INR() function across public fields, while still pulling those values back into backend equations via =REVINR() to execute complex tax projections or summaries. Comprehensive Installation Guide
Because the add-in relies on the older .xla extension (used primarily up to Excel 2003 but still fully operational on modern versions of Microsoft Support for Excel ), it must be linked manually using Excel's built-in developer tools.
The "Suresh" in "Sureshaddin" suggests the add-in was created or published by an individual named , possibly as a personal project to share a practical solution. The earliest mentions of this add-in appear in blog posts and forum discussions from around 2013 . One such blog, "Welcome to a New Era" by "coolnazmeer," published a post in July 2013 detailing how to install and use "SureshAddin.xla".