I learned from the answers myself because I used to just type an apostrophe
before entering the number then the zero would appear.

"Shannon" wrote:

I often enter manufacturer model#'s into my spreadsheet. If they begin with
zero Excel automatically the zero. What can I do to change this?