when I type in 0 it does not show
 

When I type an account number beginning with 00--the zero 'sis not showing up
in the cell. Not sure the problem as it just started with this cell-no
problems prior inserting 0's.

when I type in 0 it does not show
 

You can preformat the cell as Text (format|cells|Number tab|Text)

or you can start the entry with an apostrophe: '001234

or you could give the cell a custom format that will show as many digits as you
want:
Format|cells|number tab|custom category
00000
(I used 5 digits)

mjkbcfan wrote:

When I type an account number beginning with 00--the zero 'sis not showing up
in the cell. Not sure the problem as it just started with this cell-no
problems prior inserting 0's.

--

Dave Peterson

when I type in 0 it does not show
 

Either start your number with hyphen or format the cell as a text cell. This
will allow any 0 in the beginning to show.

Mike F.

"mjkbcfan" wrote:

When I type an account number beginning with 00--the zero 'sis not showing up
in the cell. Not sure the problem as it just started with this cell-no
problems prior inserting 0's.

when I type in 0 it does not show
 

Hyphen is -
I bet you meant apostrophe (') or a single quote.

Mike F. wrote:

Either start your number with hyphen or format the cell as a text cell. This
will allow any 0 in the beginning to show.

Mike F.

"mjkbcfan" wrote:

When I type an account number beginning with 00--the zero 'sis not showing up
in the cell. Not sure the problem as it just started with this cell-no
problems prior inserting 0's.

--

Dave Peterson

when I type in 0 it does not show
 

If these zeroes are numbers (not text), or the results of a formula, you may
need to check "Zero values" in Tools - Options - View tab.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"mjkbcfan" wrote in message
...
When I type an account number beginning with 00--the zero 'sis not showing
up
in the cell. Not sure the problem as it just started with this cell-no
problems prior inserting 0's.