View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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