Excel SpreadSheet

[William E. Storey II]

i am making a spread sheet which involves a lot of sku number and when ever
i type a sku number that begins with 0 the zero disappears when ever i go to
the next cell and will not print either how do i fix this?

any help will be appreciated

 

[Mei Chan [MSFT]]

If you highlight the cell and change the format of the cell to something
like text, it will accept the beginning zero.

1. Highlight the cells of interest.
2. Click on Format -> Cells ...
3. On the Number tab, choose "text" or perhaps you can create your custom
setting for this.