Menu

* *

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.

- Select the cell containing text.
- Right Click the text and choose FORMAT CELLS.
- Choose TEXT format for the cell.
- We can also choose TEXT FORMAT from the HOME TAB directly.

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

or

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.

**STEPS:**

Select the cell containing text.

- Right Click the text and choose FORMAT CELLS.
- Choose TEXT format for the cell.
- We can also choose TEXT FORMAT from the HOME TAB directly.

- LEARN BASICS OF NUMBER FORMATTING HERE.

A situation may arise when we need the leading zero and still number needs to be a part of the function or formula, it needs to behave like a number only.

The SOLUTION 1 won’t work for this as if we convert the format to TEXT, it won’t be able to participate in a function or formula.

Here we’ll make use of the custom format.

CUSTOM FORMAT IS THE FINAL DESTINATION FOR ALL FORMAT RELATED PROBLEMS.

- Right click the cell (which needs the format change) and click format cells.
- The format dialog box will open.
- Go to the bottom and choose CUSTOM.
- Click on GENERAL and delete it and enter 000… and look on the top of the dialog box, where sample is shown.
- Stop when sample shows the format you want.
- Click ok

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.

RANGE |

1 |

3 |

23 |

4 |

54 |

5 |

6 |

OTHER WAYS TO REACH THIS ARTICLE

## WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.

- PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
- KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON gyankosh060309@gmail.com

%d bloggers like this: