Hiding number parts by cell formatting
 

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?

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

Hiding number parts by cell formatting
 

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?

"Gary''s Student" wrote in message
...
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

Hiding number parts by cell formatting
 

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.

"Bill G." wrote:

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?

"Gary''s Student" wrote in message
...
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

Hiding number parts by cell formatting
 

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!
================================================== ===


"Bill G." wrote in message
...
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?