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.
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Is it possible to display # signs in place of a number in Excel?
20th Mar 2012
Answers (1)
0
Votes
Display # signs in place of numbers
You could add a column with a formula to display a repeating character based on the length of the numbers. Then hide the numbers column for printing.
=REPT("#", LEN(B7)) where B7 is the cell with the number.
=REPT("#", LEN(B7)) where B7 is the cell with the number.
4th Jun 2012
