Hiding number parts by cell formatting
First make sure the part number is entered as text rather than true numbers.
This will allow you for format sections of the number.
Click on a sample cell, and in the formula bar, hi-light the characters you
DON'T want to see. For these characters, format the font color the same as
the background color. This is tedious if you have lots of parts.
If you have lots of parts in a single column, then, in a helper column enter:
=RIGHT(A1,10) and paste down
Then hide column A
--
Gary''s Student - gsnu200723
|