View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim
 
Posts: n/a
Default Number format in cells

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