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

By COtte ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Display # signs in place of numbers

by Al Kostiuk In reply to Is it possible to display ...

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.

Related Discussions

Related Forums