Forum Discussion
Format cells
Hi All, I would like your help on the following. I have an excel workbook with several tab that point between them. One particular is capturing the data from other tab cells and is formatted as ...
To change the custom currency format to show blank when the cell is empty, you can use the following steps:
- Select the cells that you want to format.
- Right-click and select “Format Cells” from the context menu.
- In the “Format Cells” dialog box, select “Custom” from the list on the left.
- In the “Type” text box, enter #,##0.00;-#,##0.00;
- Click “OK” to close the dialog box.
This will format your cells with a custom currency format that shows blank when the cell is empty.
I hope that helps!