View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Cells display nothing IF

The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!

"Peo Sjoblom" wrote:

Custom format

General;

will only display zero and greater


using the same for a 2 decimal number format

0.00;

add a semicolon to the end if you don't want to display zero

0.00;;


--
Regards,

Peo Sjoblom


"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?