Zero keeps disappearing in my Excel spreadsheet column

342785 pts.
Tags:
Microsoft Excel
Microsoft Excel 2007
Microsoft Excel spreadsheet
So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example:
012345678
changes to
12345678
What do I have to do keep the zero as entered and not disappear.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Select the range of cells that will contain numbers with leading zeros.  Right click the group and select “Format Cells”.  Choose the Number tab.  Select “Text” from the list of categories.  Now, the information entered into the cells will be treated as plain text, and will appear exactly as entered.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • bhannah
    I suspect that range of cells has been set to not show leading zero's in the format.  If that is the case, then when you enter data into that cell or cells it will delete the leading zero from the data.  You will have to change the formatting  of the range of cells by selecting the range of cells, right click and select format.  This will be give you a number of options.  You will have to find the option that fits you.  I suspect that general will fit as this format does not delete leading zero's but leaves them in place.
    1,290 pointsBadges:
    report
  • jinteik

    or another way is to put ' infront of 0

    so to use your example    '012345678

    17,370 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following