- Select the data range C3 to C24.
- Then press Ctrl+1, select the Number tab, and then Custom.
- In the Type box, enter 0;;;@ then select OK.
To display hidden values:
- Select the data range C3 to C24.
- Then press Ctrl+1.
- Select the Number tab, then General.
- Select OK.