First of all, wouldn't it be great if we have a built-in function in Microsoft Excel to Convert Numbers to Letters? It means, simply, by using a formula in excel, I could Spell Numbers in Words. In banking or accountancy, this is used to write grand total amounts....
Results for "convert"
VBA to Convert Contact Data in Excel to VCF format
Dear Friends, As you have learned about interacting with Text files through Excel VBA, it is time to see the usage of those methods you learned. One usage, you have already seen here, in how to export excel data in CSV format.In this article, I am going to teach you...
User Defined Function in Excel to Convert Currency to Words
Many times we require to change the Numbers in Words. For Example 6734862=Sixty Seven Lakhs Thirty-Four Thousand Eight Hundred Sixty Two. In Excel, there is no Formula as such to Convert Numbers into Words. I have written one UDF : User Defined Function. After using...
Calculate MOD of Large Numbers in Excel
Excel Trick to Calculate MOD of Big Numbers. This article is all about MOD function in Excel. Every aspect of the MOD function is covered here in this article. At the end of this article, I have also explained a VBA code to calculate the MOD of large numbers. I have...
Complete Guide to Strings in Excel VBA: [Tips, Techniques, and Examples]
Strings, or text data, play a significant role in data processing and analysis in Excel VBA. Whether you're cleaning data, extracting specific information, or formatting text, mastering string manipulation techniques is essential. In this article, we'll explore...
A Complete guide to Array in Excel VBA
A complete guide to learning Array in Excel VBA programming. If you have done programming in any language C, VB, Java, Python, etc., you must have definitely heard and known of Array. The array is a data structure that stores data in a sequence. Each of its elements...
Difference between .Text, .Value and .Value2 in Excel VBA
One of you raised a question about which property should I be using to get the value of a cell or range - . Text, .Value or .Value2 Most of the time you might have seen all 3 methods being used interchangeably. Rather than answering them in a comment, I thought of...
VBA Code – Change the Case of existing Texts in a Sheet
In this article, I am going to share a VBA code that can be used to change the cases of texts written in an excel worksheet. This can be used to enforce proper casing on texts written in a sheet or cell range. As you know - casing can be of 3 types: 1. lower, 2. UPPER...
Downloads
FREE Tools & Templates to DownloadMacro Enabled Tool Distance Calculator in Excel This tool is to show how to use Google API to calculate the distance between two places. It is explained here in this article in detail. Download this Excel tool and learn with fun...
Invoice Template [ FREE Download ]
Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets. I manage my...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
VBA: Reverse a string
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
Data Anonymizer: Open Source to Anonymize Personal Data
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...
Custom Excel Formula to Count based on Color
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...