| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format cells to show the number 0 as first number in seri
Subject line pretty much says it all. Is there a way to format cells to show
0's before other digits in a series of numbers without using "Text" formatting? I am trying to input UPC's, some of which begin with 1 or 2 zeros and I can't get the zeroes to show up unless I choose "text" formatting. I am using Office 2007. Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell so number entered will show only one way | Excel Worksheet Functions | |||
| I need a custom format of this number 70226 to show it 02/26/07. | Excel Worksheet Functions | |||
| conditional format of number? -- show decimal ONLY IF not 0 | Excel Discussion (Misc queries) | |||
| Pivot Table Question: Show percentages and standard number format | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Threaded Mode
