There is nothing to be done if we need to add zero to the text.
Simply, add the zero anywhere in the field and it would sustain. If somehow there is any problem, follow the following steps.
Adding leading zero to a number is the tricky one for many of us.
Suppose we have enter the bank account number. some bank account numbers have leading zero
We want to create a series and want to have that all the number have same number of significant digits.
In both of the cases we are in trouble.
The Excel removes all the leading zero from the numbers which we type in Excel. So it becomes a problem for us.
We have many solutions for this problem. We’ll discuss the main two of them. But the solution will depend on the
nature of the requirement.
If the number, which needs the leading zero, need not to be involved in any type of mathematical task, which means
that we are not going to apply any formula on that number, we can simply change the format of the cell to TEXT.
Select the cell containing text.
Let us find out the last used row in a column i.e. the row which contains the last data in a row. We can take the leads from the above examples of finding the last used cell in a column.
Let us try to check the cells of a column and find out the last filled cell in a column. Usually this kind of task is easily done in VBA but we will still try in Excel. We’ll take help of LOOKUP function in this as this is a very basic function for looking up a value in a given table and it runs throughout the range.
Suppose We have the following data in a column.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE