LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ellen
 
Posts: n/a
Default how to have result field blank

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank field formatted as date Emily8 Excel Worksheet Functions 5 October 11th 05 07:54 PM
How to .. sbgvp Excel Discussion (Misc queries) 8 October 4th 05 09:16 PM
excel melissa Excel Worksheet Functions 2 August 19th 05 09:46 PM
How can i change this VBA project According to Indian Numeric Rao Ratan Singh Excel Discussion (Misc queries) 1 April 21st 05 07:53 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 05:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"