Hiding Numbers with a Custom Format

Excel - Formatting and Reports

If you want to hide a number in the display, but keep it for use in calculation, then create a custom format with no formatting codes between the segment. For example if you want to only show positive numbers create a custom format like this,


Share the power...