Formats numbers into Indian Lakhs and Crores.
The add-in introduces custom formulas that handle currency formatting and text conversion:
Go to File > Options > Trust Center > Trust Center Settings > Macro Settings . Choose the option to Disable VBA macros with notification or Enable VBA macros . Alternatively, you can add your custom folder to the Trusted Locations panel so Excel knows it's safe to run. Modern Alternatives to SureshAddin.xla Sureshaddin.xla
Ensures all documents adhere to Indian accounting formatting (Lakhs/Crores).
| Problem | Example | | :--- | :--- | | | ₹1,23,456 appears as ₹123,456 | | Manual conversion of numbers to words | Writing “One Crore Twenty Three Lakh Forty Five Thousand Six Hundred Seventy Eight” for ₹1,23,45,678 | Formats numbers into Indian Lakhs and Crores
' 1. Toggle Gridlines Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton) With MenuItem .Caption = "Toggle Gridlines" .OnAction = "ToggleGridlines" .FaceId = 364 ' Icon for grid End With
Master Excel Currency Formatting with SureshAddin.xla The designed specifically to help accountants, finance experts, and Indian businesses seamlessly format numeric values into the Indian Numbering System and automatically convert those figures into written text (e.g., converting 100,000 into "Rupees One Lakh Only"). Alternatively, you can add your custom folder to
is a classic, specialized Microsoft Excel add-in engineered to streamline financial documentation by automating the conversion of numeric figures into words using the Indian Numbering System (Lakhs and Crores) .
:
Add-ins like Sureshaddin.xla are designed to inject custom functionality directly into your Excel environment. Instead of writing the same VBA macros repeatedly in every new workbook, an .xla file loads automatically in the background, making its tools universally accessible across all your spreadsheets. Common Use Cases for Custom .xla Add-ins