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
 
Back
Top