How to make a number starting with 0 to keep showing it in Excel?

  • Thread starter Thread starter Caitlin
  • Start date Start date
C

Caitlin

Example: When entering 0315684 into an Excel cell it then automatically
becomes 315684. How do you retain the 0?
 
If you want the cell to remain in number, right
click>FormatCells>Custom>Enter the number of zeroes. For example if you want
the entire column to be zero padded with 6 digits you can enter 000000

OR

If you data is only a text then preformat the column or cell as text, or
enter this with a single quote in front '0315684 which will tell excel that
the value you are entering is text

If this post helps click Yes
 
If you want the cell to remain in number, right
click>FormatCells>Custom>Enter the number of zeroes. For example if you want
the entire column to be zero padded with 6 digits you can enter 000000

OR

If you data is only a text then preformat the column or cell as text, or
enter this with a single quote in front '0315684 which will tell excel that
the value you are entering is text

If this post helps click Yes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default number format in Excel 1
Displaying zeros in cells 2
Red cell for negative numbers in Excel 1
How to separate text and numbers in one cell or column? 12
numbers starting with 0 5
Convert Number to Text for Index/Match 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Auto row insertion based on a number 6

Back
Top