View Single Post
  #5   Report Post  
Duke Carey
 
Posts: n/a
Default how do you make negative numbers show up as 0 in Excel?

I offered a different solution only because sometimes the posters don't
realize the consequences of what they are asking for. You have a good day,
too

"tiah" wrote:

Hi Duke !

I know this is a display, but i answered to the question !

he ask for a way to "show" 0 and ask for a "format" to "display"

=)

sure i would use your formula :)

have a nive day !