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
|