Hiding number parts by cell formatting

[Bill G.]

Hello. I have several cells with numbers, whose digits range from 10 to 13.
I want to show only the last 10 digits for every number. Not actually delete
the first few digits, but have them not show, by cell formatting probably. I
have played a bit with custom cell formatting but there is few info on the
web about the signs that can be used and their function. Any advice?

 

[Guest]

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

 

[Bill G.]

So there is no way to use number formatting to do what I want eh? Coz I want
to avoid marking the numbers as text because it pops up that error label (as
of Excel 2007)

Plus, do you know any websites that provide info on custom number
formatting?

 

[Guest]

Not sure of your exact situation, but how about having a second column with
this formula =A6-(INT(A6/10000000000)*10000000000) where the original
number(s) is in cell A6. You could then hide the column with the full number.

 

[RagDyeR]

Say your numbers are in Column A.
Insert a column after your column of numbers, to make a new Column B.

Enter this formula in the new B1:

=RIGHT(A1,10)

And copy down as needed.

Hide Column A.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hello. I have several cells with numbers, whose digits range from 10 to 13.
I want to show only the last 10 digits for every number. Not actually delete
the first few digits, but have them not show, by cell formatting probably. I
have played a bit with custom cell formatting but there is few info on the
web about the signs that can be used and their function. Any advice?