| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display 0 in eg 021796 - not as text?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I display 0 in eg 021796 - not as text?
custom format the number as 000000. -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=544387 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I display 0 in eg 021796 - not as text?
Use a custom format 000000
note that this will not be dates that excel can read without either using vba or help formulas, to excel this will be ten thousand one hundred fifteen Regards, Peo Sjoblom "ctjakkals" wrote: How can I display the leading 0 in a number without having to change the cell format to text? eg yymmdd 010115? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display the "ampersand" in the header as text | Setting up and Configuration of Excel | |||
| wrapped text does not display | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Hybrid Mode
