Excel functions can help you a lot in your work. In this article, we will discuss about the difference between the built-in ROUND function and the VBA ROUND function.
You will certainly have used the ROUND function in your Excel. If you also use VBA to finish some tasks, you may also have used the ROUND function in codes. However, the built-in ROUND functions in worksheet and in VBA codes work differently. Below we will show you how they work differently.
Built-in ROUND Function
In this...
Read more »
By default, when you forward a meeting invitation, Outlook will automatically send a notification mail to the meeting organizer. If you dislike this, you can follow the 3 simple tricks introduced in this article.
As usual, when you intend to forward a received meeting invitation by clicking on “Forward” button on “Home” tab of Mail section, you will receive a reminder that a meeting forward notification will be sent to the meeting organizer. It looks like the following image:
Then the...
Read more »
In an Excel worksheet, you may need to extract numbers from values in cells. And in this article, we will introduce you two methods to extract numbers from Excel cells.
There are many cases that both numbers and texts are in same cells. In order to better analyze those values, you will need to extract the numbers and texts. The image below shows such an example. In column A, there are the ID and the name of products.
Now you need to input the product ID into column B in the worksheet. And...
Read more »
