Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi everyone, and thanks for any help. I can normally find someone on here
that as an answer to my questions. I am running XP Pro, SP2, and Office Pro 2003. I have a column for part numbers. The part numbers range from 00-1000 through 99-9999. I have set up a custom number format for the cells of 00-0000, so I don't have to enter the hypen when I key in a number. The problem is when I enter a number with a leading zero, i.e. 05-3258. If I key in 053258, the number displays in the cell as 05-3258. However, in the edit box the number displays as 53258. When I do a search, I have to remember not to enter the leading zero in the search box, or it won't find the number. Is there a way to establish a format picture that will display the leading zero in the edit box, as well as in the cell? -- Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
Change number format from text to number? | New Users to Excel | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |