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

C

Caitlin

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

Jacob Skaria

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
 

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

Excel does not accept text format! 0
Paste to excel from word - auto format problem 1
Paragraph numbering in Word 1
Word doc keeps changing to ALL CAPS 0
Convert Number to Text for Index/Match 1
Finding the proper style field and the numbered paragraph value within the style 0
Table Header Cells keep shifting 8
Auto-Numbering in a Table in MS Word 1

Top