Found 2044 Articles for Microsoft Technologies

When we need to convert numbers to words in Indian rupees in Excel, it can be a time‑consuming process if we do it manually as we need to type the large numbers. We can complete this time-consuming process much more quickly by using the VBA application. Even though the VBA code will be lengthy, we can use this process if there are many values to convert. Read this tutorial to learn how to convert numbers to words in Indian rupees in Excel. Converting Numbers to Words in Indian Rupees in Excel Here we will create a new VBA module, then ... Read More

Sometimes in Excel, you may have observed that the date and time are represented as strings without any separators. This could create a huge problem if we perform any operations on the data and analyse them. If we try to do this conversion manually, then it will be a time‑consuming process. However, you can speed up this process by using the tricks mentioned in this tutorial. Read this tutorial to learn how you can convert a number string to a date and time in Excel. Converting a Number String to Date and Time in Excel Here we will use the ... Read More

Generally, in Excel, when using the US format, the numbers will be like 3432.12, but in the European format, the same number will be typed as 3432.12. This can occasionally lead to misunderstanding. So, we need to convert US format to European format for more accurate analysis and simplicity. Read this tutorial to learn how you can convert number formats in Excel between European and American. Converting Number Format from European to US in Excel Here we will use the NUMBERVALUE formula to get any one of the results, then use the autofill handle to get all the results. Let's ... Read More

The default format for Excel files between Excel 97 and Excel 2003 is Xls, and the above versions have the default format of Xlsx. Both are Excel file extensions. If there are any old files in our system and we need to use the new features on them, then it is very necessary to convert them to a new extension. If there is only one file, we can use the "save as" function to complete the task, but it can be time-consuming for multiple files. We can complete the task using the VBA application in a faster way. Read this ... Read More

Sometimes, while working in Excel, you have needed to convert an Excel workbook to PDF. It can be a time-consuming process if you try to do this manually. We can complete the task using the VBA application as it can’t be completed directly in excel. Read this article to learn how you can convert multiple workbooks or worksheets to PDF files at once in Excel. Let us see the procedure in a briefer way. Converting Multiple Workbooks to PDF Files at Once in Excel Here we will first create a VBA module, then run it to select folders that contain ... Read More

When we have a list of plain email addresses in Excel, It could be irritating as we can’t send mail to them directly. If we need to convert them to hyperlinks, we can do so directly, but sometimes it could be a boring and old process if we do it many times. So let us see an interesting method to complete the task using the VBA application. Read this tutorial to learn how you can convert multiple email addresses to hyperlinks in Excel. Converting Multiple Email Addresses to Hyperlinks in Excel Here we will first insert a VBA module and ... Read More

Sometimes in Excel, the time period is represented only in months that are longer than 12 months. This can lead to problems when we are trying to analyse our data or perform any operations. So, it is very important for us to confine those values to years and months to make the value smaller and clearer, which can save our time and increase our work efficiency. Read this tutorial to learn how you can convert months to years and months in Excel. For instance, 56 months equals 4 years and 8 months. Converting Months to Years and Months in Excel ... Read More

In Excel, you may have needed to convert the month name to a number at times. like January as 1, February as 2, and so on. number is nothing more than their occurrence order number. Read this tutorial to learn how you can convert a month's name to a number and vice versa in Excel. We can complete both tasks using the VBA application. Here we need to use the help of the VBA application, as it can't be completed directly using the formulas. Converting Month Name to Number in Excel Here we will insert a VBA module and then ... Read More

If the data in the sheet is given in milliseconds, then it can be very confusing, and you will not be able to perform any operations on it as it will be a very large value. Generally, one millisecond is equal to 1/1000 second. If we need to find the duration from the milliseconds, we can use this process. This tutorial will help you understand the process of converting milliseconds to time in Excel. If you try to do it manually, it will be time-consuming and inaccurate. So, in this tutorial, we will try to convert milliseconds to duration using ... Read More

If the time is represented in 24-hour format without any separator, then it can be called military time. If the times are in military format, then it is impossible to perform operations on them, and it can be confusing while we are understanding our data in the sheet. So, we need to convert them to a standard format for a more accurate understanding of the data. Read this tutorial to learn how you can convert military time to a standard format in Excel. Converting Military Time to Standard Time in Excel Here we will use the TIMEVALUE formula to get ... Read More