The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

how to type numbers starting with zeros in excel

how to type numbers starting with zeros in excel


I tried typing an account number that starts with zero digit in excel but anytime I type zero it disappears and I tried formatting the cell but not getting what i need. Please can you tell me other ways to get this done in excel? Thank you

2 Answers

365 Team

Hi Eze!
Thanks for reaching out.
Can you please double-check the link provided? I arrive at a “page not found” error. This may help us assist you better. Thank you.
Otherwise, if I’ve managed to correctly understand your question, you may only need to indicate you want the marked cells to be of Text format, and then retry inserting values starting with 0.
Furthermore, these values could be used for calculations.

Hope this helps.


Hi Ezel,
So that you can insert leading zeros in a numerical cell, do the following:

  1. Right click on the desired cell (or range of cells) and select “Format Cells…” from the context menu.
  2. Select “Custom”.
  3. In the “Type” field (where it is initialised with the word “General”), type how many leading zeros you want to allow followed by one # sign.
    For example, if you want to allow 3 leading zeros, type: 000#


Hi Haydar! Thank you very much for your comment! Surely, this will help Ezel and other students reading from this thread. Kind regards, Martin

4 months
Complete Data Science Education
Get 50% OFF