View Single Post
 
Old 01-27-2014, 12:42 PM
bhum bhum is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2014
Posts: 1
bhum is on a distinguished road
Default 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?
Reply With Quote