Use a custom format so that a zero value generates nothing. If you want the
accounting format, with this one exception, set the accounting format. Then
Format Cells. On the number tab select Custom category. In the text box
you'll see the incantation that equates to the accounting format. Clear the
part following the second semicolon and click OK.

"Ellen" wrote:

In a workbook, have a data entry sheet that is protected except for fields
for answers. These fields (shaded yellow) are formatted as accounting. The
yellow fields on the Data Entry worksheet populate other cells in the Webinar
Cost Calculator and Webinar ROI Calculator worksheets. If a cell on the Data
Entry screen is blank, I want it to return a blank, not a 0 or a -, which
it's currently doing. Can excel format the result when there is no data to
return a blank?