Is it possible to display # signs in place of a number in Excel? - TechRepublic
Question
March 20, 2012 at 01:18 PM
cotte

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

by cotte . Updated 14 years ago

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 discussion is locked

All Comments