Question Locked

Is it possible to display # signs in place of a number in Excel?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by al kostiuk

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.

This discussion is closed to new replies.