how to not display a certain result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to not see any formula results that come up as 0:00, is this
possible for the whole spreadsheet?
 
use a custom number format like this
hh:mm;;

the semicolons tell excel to make the cell blank if the value is negative or
zero. custom number formats work like this...

+numbers;-numbers;zero;text

each section can be formatted differently.
 
Try Tools - Options - View - Zero values (unchecked).

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Tools>Options>View tab, uncheck Zero values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to not see any formula results that come up as 0:00, is this
| possible for the whole spreadsheet?
|
 
A lot depends on what your cell values are. Formatting a cell as time, any integer value will show
as 00:00, despite not being truly zero, so the suggested fixes -may- not work (though they probably
will).


HTH,
Bernie
MS Excel MVP
 
Bernie,

I had my doubts too, but the Zero Values option seems to work with a time-formatted cell.

If by chance the OP has a midnight value including the date part, and it's formatted for
time only, then it won't work. We'll see.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
 
Back
Top