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

Example: When entering 0315684 into an Excel cell it then automatically
becomes 315684. How do you retain the 0?

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

If you want the cell to remain in number, right
clickFormatCellsCustomEnter 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
---------------
Jacob Skaria


"Caitlin" wrote:

Example: When entering 0315684 into an Excel cell it then automatically
becomes 315684. How do you retain the 0?