Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i REALLY need a VLOOKUP EXPERT | Excel Discussion (Misc queries) | |||
some charts will not show trendlines | Charts and Charting in Excel | |||
multiple results display after filter function | Excel Worksheet Functions | |||
How to make a cell show totals | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel |