=REVINR(Cell_Reference) : Reverts the text-formatted INR result back into a standard number format so it can be used for further mathematical calculations.
Master Your Excel Reports with the SureshAddIns.xla Tool Tired of manually typing out "Rupees Five Thousand Only" for every invoice? If you handle Indian payroll, accounting, or tax filings, you know how tedious it is to format numbers into the Indian currency system. Enter SureshAddIns.xla
: 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)
' 1. Toggle Gridlines Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton) With MenuItem .Caption = "Toggle Gridlines" .OnAction = "ToggleGridlines" .FaceId = 364 ' Icon for grid End With
Here is how to put together the feature set. Sureshaddin.xla
: It was widely used in older versions of Excel (like 2007) to handle the Indian numbering system (Lakhs and Crores), which standard Excel formatting did not support natively at the time. Installation Steps
Typical uses for a custom add-in like this include:
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.
: Ensuring that the "Amount in Words" section matches the numerical total perfectly. Banking and Compliance Enter SureshAddIns
The file is a classic, legacy Microsoft Excel Add-In designed to automatically convert numerical figures into text formatting using the Indian Rupee (INR) numbering system . Financial analysts, accountants, and tax professionals heavily rely on this specific toolkit to streamline invoice generation, tax form filing, and payroll calculations without resorting to manual text entry or complex VBA scripts.
Do not move the .xla file after installation, otherwise Excel may lose its reference.
: Relying on an outdated, third-party add-in from a potentially unknown source carries inherent security risks. Excel files with macros ( .xla , .xlsm , .xlam ) can be vectors for malware. It's always safer to use built-in features or create your own trusted VBA code.
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". : It was widely used in older versions
is a popular, lightweight third-party Microsoft Excel add-in engineered to automate financial formatting and convert numeric digits into localized Indian text. In international accounting, standard functions process currency through the Western millions and billions format. However, financial systems in South Asia rely on the Indian numbering system, which groups digits by lakhs and crores. This tool introduces dedicated User-Defined Functions (UDFs) to process these distinct structures natively within spreadsheets. Key Functions of Sureshaddin.xla
Sureshaddin.xla is a file with an .xla extension, which typically indicates that it is an Excel add-in file. This file type is used to extend the functionality of Microsoft Excel by adding custom tools, macros, and features. However, the presence of Sureshaddin.xla on a computer system often raises more questions than answers.
This comprehensive technical guide covers the purpose, architecture, installation, troubleshooting, and modern alternatives for the Sureshaddin.xla file. 1. What is Sureshaddin.xla?
: Formats a standard western digit grouping into the traditional Indian laconic system. Instead of formatting 1500000 as 1,500,000 (Western millions), it groups the value as 15,000,000 or 15,00,000 (15 Lakhs) according to South Asian punctuation rules.