How do you enter a number starting with 0 in Excel sheet?

Answer 1

You can not enter a number starting with zero, since Excel will automatically discard any leading zeros as insignificant digits in a number. However, you can enter a string of numbers starting with zero if you format the cell as text.

You can format a cell as text two ways: 1) use the cell format option, or 2) enter the apostrophe (') as the first character in the cell.

A comon reason for entering a leading zero is when you enter US zip codes. If you want to enter the APO zip code 09173, Excel would automatically display it as 9173, unless you format the cell as text.

EXAMPLE:

Formatted as number: 09173 = 9173

Formatted as text: 09173 = 09173

You can still use the number in calculations by using the VALUE function, which converts a text value into a number. So if the number was in cell A2 and formatted as text you could use the value in a function like this:

=VALUE(A2)*10

__________________________________________________________________

Cells can be formatted to display numbers with leading zeros without converting them to text.

If, for example, you want all of the numbers in a range of cells displayed as at least three digits, giving leading zeroes to one-digit and two-digit numbers, after selecting the range go to Home/Number, then under the Number tag of the Format Cells window choose Custom from the list of categories, and in the Type: field enter 000

Answer 2

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Answer 3

Starting a number with zero has no impact on using it without a zero at the start. So 020 is the same value as 20. For this reason the zero will be dropped. If you want to keep a zero, like for a phone number or a code, then you have to treat the number as text by putting in an apostrophe before it like this:

'020

The number will now be stored as text and the first zero will stay.

Answer 4

Go to the cell where you want to enter zero and type "0" in the cell.