Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Parts of Formulas | Excel Discussion (Misc queries) | |||
Split a number in a cell into parts | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
hiding parts of a cell | Excel Discussion (Misc queries) | |||
hiding parts of a cell | Excel Discussion (Misc queries) |