| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel chart showing movable graph at what point we make a profit | Charts and Charting in Excel | |||
| how to format cell in excel for 12 digit number starting with a 0 | Excel Discussion (Misc queries) | |||
| excel doest not shows the number starting with 0..is there is any way to solve this. | Excel Discussion (Misc queries) | |||
| how do you make a summary page showing the workbook name with the excel sheet names | New Users to Excel | |||
| How can I make a formula in Excel showing when the file modified? | Excel Worksheet Functions | |||
Hybrid Mode
