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? |
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) |