π
: Reverses the string format back into raw mathematical data. It strips away custom Indian punctuation and commas, transforming the cell into a calculable format for subsequent arithmetic operations. Step-by-Step Installation Guide
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:
Suppose you have a sales report with amounts in column C. You want to display each amount in both the Indian comma format and in words: Sureshaddin.xla
is a popular Microsoft Excel add-in used primarily in India to automatically convert numerical figures into words in the Indian Rupee format (Lakhs and Crores).
Add-ins like Sureshaddin.xla are package files that hold VBA modules, forms, and class modules. Instead of rewriting complex formulas across multiple workbooks, developers bundle their code into an .xla file. Once installed, the custom formulas and tools within Sureshaddin.xla become globally accessible across any Excel spreadsheet opened on that specific computer.
Installing this addβin is straightforward, though the exact steps vary slightly depending on your Excel version. π : Reverses the string format back into
Please exercise extreme caution when downloading .xla or .xlam files from the internet, especially from personal blogs or unknown sources. These files can contain harmful macros or viruses. Only download files from trusted sources, and after downloading, it is strongly recommended to scan the file with up-to-date antivirus software before attempting to use it.
Formats numerals using the traditional Lakh and Crore intervals (e.g., first comma at the hundreds place, followed by commas every two digits thereafter).
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 Add-ins like Sureshaddin
The activation pathway varies slightly depending on your version of Excel, but remains uniform across standard Windows platforms:
In the Excel Options dialog box, click on the category on the left sidebar.
: Obtain the SureshAddin.xla file and save it to a permanent location on your computer.