Hiding Numbers with a Custom Format

Excel

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,

#,##0.00;;

Share the power...