Excel Solutions

2 Effective Methods to Keep Leading Zeros in Cells in Your Excel Worksheet

When you input leading zeros into cells, you will find that Excel will remove zeros from cells. Here we will introduce two methods to keep them in the cells. There are cases that you will input numbers with leading zeros. However, even if you manually input the zero into cells, you cannot see it when you press “Enter”. This will cause trouble to you when those leading zeros have special meanings. In order to help you solve this problem, you can use the two methods below. Method 1: Input...

Read more »

How to Create a Calendar in Your Excel Worksheet with VBA Script

Excel has a wide range of usage. In this article, we will show you how to create a calendar in a worksheet by using a macro. Except for storing and analyzing data in your Excel, you can also use it to finish other tasks. For example, you can collect information by using Excel, or you can note down your planning in the worksheet. Today we have found a new usage. You are able to create a calendar in a worksheet. You can see the effect in the image below. You can input some tasks into this...

Read more »