Thread: How to make a number starting with 0 to keep showing it in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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?
Reply With QuoteReply With Quote