Entering numbers as text!

Question 1

If the number is entered in a format which begins with a zero, what will Excel do?Explain with an example

Answer 1

If the number is entered in a format which begins with a zero, Excel will drop the leading zero. Ex- 01481 will become 1481

Question 2

What to do if you want to preserve the leading zero and why?Explain with the help of an example.

Answer 2

To preserve the leading zero, like in the case of telephone area codes, roll no. etc, type an apostrophe before the number.Ex- ‘01481

Question 3

What happens when you type an apostrophe before the number?

Answer 3

The number is treated as text and displays it in the exact format as it has been entered.

Question 4

How do formulas and functions treat the zero typically?

Answer 4

Typically, formulas will treat the entry as a zero and functions will ignore it.

Question 5

So basically, how to enter a number as text?

Answer 5

Type an apostrophe before the number so it treats the number as text and displays it in the exact format as it has been entered.