Changing the Cell Formatting from Date to Number in Microsoft Excel

To change the cell format from date to number we convert the formatting into General Format in Microsoft Excel. There are three different ways to c...

Changing the Name of the Cell Comments Author in Excel

Before learning about how to change the author name in the comments box, we have to understand about the comments. What are comments and how we can id...

How to Copying a Cell Comment

Before we learn about how to copy comments in a sheet, we have to understand about the comments. What are comments and how can we identify that if it ...

Combining Text and a Formatted Date in Excel 2010

Sometimes when we prepare analysis reports, we show the date with text and if we want to make any changes in data it should be updated automatically i...

Combining Text and Formatted Values in Excel 2010

In this article we will learn about how to combine the text and formatted values in Microsoft Excel 2010. Sometimes when we prepare analysis report...

Copying and Pasting Validation list only in Microsoft Excel

When copying a cell that contains validation criteria to a different cell, the criteria are copied along with the text formula and format. If you wan...

Preventing Duplicates While Entering Data in Excel 2010

In this article we will learn about how to prevent duplicates while entering the data in Microsoft Excel 2010. We can use Countif formula to prevent t...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube