Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank field formatted as date | Excel Worksheet Functions | |||
How to .. | Excel Discussion (Misc queries) | |||
excel | Excel Worksheet Functions | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |