Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Computers Articles
Page 48 of 100
How to Convert Zeroes to Dashes in Excel?
Sometimes in Excel, you just need to convert the zeros to dashes to represent that there is no value in the cell. We can do this task if we treat zero as a value. If we try to solve this manually, it can be good for small amounts of data, so we need a faster approach for large amounts of data. Read this tutorial to learn how you can convert zeros to dashes in Excel. We can complete this task using the find and replace function and formal cell operation. Converting Zeroes to Dashes Using Find and Replace We'll open ...
Read MoreHow to Convert yyyymmddhhmmss Date Format to Normal Datetime in Excel?Datetime in Excel?
In Excel, we always try to show the date and time in the format of dd-mm-yyyy hh:mm:ss, which is the standard format when we use the date and time in Excel. But when the date and time are given in another format, some users may feel uncomfortable using them because they could have only used the standard format all this time. Generally, in Excel, when we enter any format of date and time in the sheet, it will be directly converted to the standard format. If we try to convert any other format to standard format manually, then it can ...
Read MoreHow to Convert Weekday String to Number in Excel?
Sometimes in Excel, you would need to convert the given day name to a number, like one for Monday, two for Tuesday, and so on. If we try to convert the days manually, we can use it if there are fewer values; when there are more values, we can’t use the manual process as it can be a time-consuming and inaccurate process. We can convert the days to numbers using the formulas to save a lot of time when performing the task. Read this tutorial to learn how you can convert a weekday string to a number in Excel. Even ...
Read MoreHow to Convert Week Number to Date or Vice Versa in Excel?
Have you ever wondered if there is any feature in Excel from which we can find the start and end dates of a week in any year without using the calendar? There is no direct way, but we can solve this task in Excel using the formulas supported by the programme. Read this tutorial to learn how you can convert a number to a date or a date to a week number in Excel. Converting a Week Number to Date in Excel Here we will first use the formulas to get the start and final data. Let's look at a ...
Read MoreHow to Convert Vertical List to Horizontal or Vice Versa in Excel?
Have you ever tried to convert a vertical list to a horizontal list, or vice versa, in Excel? Manually doing this can be time-consuming because we must type data into each cell and each new cell. We can complete this task in a faster and simpler way by using the paste special function. Read this tutorial to learn how you can convert a vertical list to a horizontal list in Excel and vice versa. The lists that are represented in vertical and horizontal ways are known as "vertical lists" and "horizontal lists, " respectively. Converting a Vertical List to Horizontal ...
Read MoreHow to Convert Vector / Single Row or Column to Matrix in Excel?
A matrix is rectangular array with n rows and m columns. Sometimes in excel when we have a data in single column or single row you would want to convert them into a matrix. If you try to solve this manually, then it can be a time-consuming process, as we need to copy each row manually and paste them. So let us see a faster process. We can solve this using the formulas supported by Excel. The only condition for the matrix is that the all the values must be filled in whole "m*n" values. This tutorial will help you ...
Read MoreHow to Convert Various Non-Standard Date Formats to Standard Date in Excel?
Sometimes you may have observed that the dates in the sheet are not in a valid format. If the dates are not valid, we will not be able to perform any operations. So, it is very important for us to know different ways in which we can convert them into a valid format. Read this tutorial to learn how you can convert various non‑standard formats to standard formats in Excel. We can solve this task by using formulas and formatting cells in Excel. Converting Non-Standard Date Formats to Standard Date in Excel Here we will use the DATEVALVE formula to ...
Read MoreHow to Convert URL Text to Clickable Hyperlink in Excel?
Have you ever tried to convert a text to a hyperlink in Excel? If you are facing any difficulty, this article will help you complete the task. The HYPERLINK function creates a shortcut that jumps to another location in the current workbook or opens a document stored on a network server, an intranet, or the Internet. When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed or opens the document you specified. If you try to convert the text to a hyperlink in Excel using the direct menu from the right-click menu, then it ...
Read MoreHow to Convert True False to Checkbox in Excel?
Sometimes when we have True or False values in Excel, you would have needed to change them to checkboxes for better and accurate analysis. We can solve this task using the VBA application, as it cannot be completed directly in Excel. Read this tutorial to learn how you can convert True to False values to checkboxes in Excel. In other words, the checkbox will be checked if the value is True, and the box will be unchecked if the value is False. Converting True False to Checkbox in Excel Here, we will first create a VBA module and then run ...
Read MoreHow to Convert Traditional Chinese to Simplified Chinese or Vice Versa in Excel?
Have you ever wondered if Excel has an inbuilt translate function that can assist us in converting between languages without the use of any external applications, such as uploading the content to the internet and performing the operations? The translator can be used to convert between the languages. Sometimes in Excel, you want to convert traditional Chinese to simplified Chinese to reach more people. As traditional Chinese can only be understood by a few Chinese people, the simplified version is easier. The most obvious difference between traditional Chinese and simplified Chinese is the way the characters look. Traditional characters are ...
Read More