How do you enter number 00123 on Excel?

How do you enter number 00123 on Excel?
by

1 Answer

Answer :

If you type 00123 into a cell it will become 123. If you want toshow the two zeroes, you need to format it as text, with thesimplest way being to put a ' in front of it like this: '00123. Itwill now be a piece of text.
by

Related questions

If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Description : If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Last Answer : If you enter 15 + 30 in a cell, Excel will display15 + 30.

The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Description : The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Last Answer : cell

The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Description : The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Last Answer : b) Cell