|
|
#1
01-27-2014, 12:42 PM
|
|||
|
|||
won't show blank cell
i have entered a formula =H14+G14-I14 in cell J14
I have set the sheet to show 0 as a blank, the cells are formatted to time but if the result in j14 is 0:00 it shows in the cell and is not blank? the rest of the cells in the sheet will be blank on 0 can someone help? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Laptop screen blank but images show on projector | riverpilot | PowerPoint | 0 | 11-10-2012 09:16 AM |
 show a cell
|
s7y | Excel Programming | 26 | 05-26-2012 08:00 PM |
| Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
| Show the first item of a drop-down list instead of a blank | Pragabhava | Excel | 1 | 12-29-2011 11:48 PM |
|
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?
|
Learner7 | Excel | 1 | 04-25-2011 04:39 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode