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
|