how to not display a certain result
 

I would like to not see any formula results that come up as 0:00, is this
possible for the whole spreadsheet?

how to not display a certain result
 

Goto ToolsOptionsView tabuncheck Zero valuesOK

--
Biff
Microsoft Excel MVP


"iamtaranicole" wrote in message
...
I would like to not see any formula results that come up as 0:00, is this
possible for the whole spreadsheet?

how to not display a certain result
 

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.

"iamtaranicole" wrote:

I would like to not see any formula results that come up as 0:00, is this
possible for the whole spreadsheet?

how to not display a certain result
 

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...
-----------------------------------------------------------------------
"iamtaranicole" wrote in message
...
I would like to not see any formula results that come up as 0:00, is this
possible for the whole spreadsheet?

how to not display a certain result
 

ToolsOptionsView tab, uncheck Zero values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"iamtaranicole" wrote in message
...
|I would like to not see any formula results that come up as 0:00, is this
| possible for the whole spreadsheet?
|

how to not display a certain result
 

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


"iamtaranicole" wrote in message
...
I would like to not see any formula results that come up as 0:00, is this
possible for the whole spreadsheet?

how to not display a certain result
 

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...
-----------------------------------------------------------------------
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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


"iamtaranicole" wrote in message
...
I would like to not see any formula results that come up as 0:00, is this
possible for the whole spreadsheet?