I have a row that contains different numbers. first 5 characters from each cell are equal, difference is only in last 3 characters (Example: 10265083, 10265154, 10265360).

I don't need to make the cell so wide as length of the number, because the sheet will be too large visually. So I need to see only last 3 characters in cell. In formula bar should be the whole number, because I need to use full number for further formulas.

Is it possible to do something like this?

CodePudding user response：

I tried all kinds of cell formatting, I didn't find any way only to show the last three digits. Therefore I opt for another approach: just create a helper column, containing the following formula: =MOD(J7,1000).