Question

If in cell A1 leading Zeros is set to 4 & we enter number 28 in this cell then how it will be displayed in cell A1​

Answer 1

Answer:To change the cell formatting we have 2 options: first is Excel Format Cells option and second is Excel Text formula.

Excel Text function is used to convert a numeric value into Text format by using special format strings. You can combine numbers with text or symbols to display the data in a more readable format.

Syntax of Text function: - = Text (value, format text)

For Example: - cell A1 contains the number 1234

=TEXT (A1,"00000")

The function will return “01234”.

This function is formatting the cell A1 using a text format and ensuring that the number in the cell has 5 digits in it by putting 5 zeros in the brackets.

Let’s take an example and understand how to put a zero (0) in front of a number.

We have a list of STD numbers in column A, now we want to add a 0 in front of each number in this list.

Explanation: