Can Excel ignore a 0 if it starts out that way

C

Cali Tech

I am trying to create a spread sheet and need to enter 0023408 and it wants
to put 23408. I need the 00 to be there. How can I turn this feature on or
off.
 
F

FiluDlidu

Right-click on the cell, go to "format cell";

Under the "number" tab, choose "Custom" in the category mini-window;

In the white space underneath "Type:", replace whatever you have in there
(possibly "General") by "0000000";

Click "OK";

Done!
 
J

Jim Thomlinson

format the cell with a custom format of

0000000

Note however that the cell hold the value 23408 and that only the format of
the cell has changed.
 
M

Max

Another option, but it'll be text numbers
Either precede the input with an apostrophe (')
or, pre-format the col as text.
 
T

T. Valko

If you have a "bunch" of numbers like that and all of them need to be the
same number of digits you can use a custon number format:

Format>Cells>Number tab>Custom

0000000

If you enter 10 it will *appear* as 0000010. If you enter 23408 it will
*appear* as 0023408. These entries will still be *numbers*.

Or, you can enter them as *TEXT*. You can either preformat the cells as TEXT
or you can precede them with an apostrope as you enter them:

'0023408
 
Top