Here is an example.
The number in the cell is: 1,234,567
Can this be displayed as: #######
The number of # signs would need to be the same length as the number in the cell. If the number is 1234, then it should display as ####.
This is for printing purposes so the printout shows there is a value of a certain length but the actual number does not print but is retained in the spreadsheet.
