View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dennis Allen Dennis Allen is offline
external usenet poster
 
Posts: 43
Default Date cell format

Thanks...Dennis

"Myrna Larson" wrote in message ...


=IF(B40,B4+180,"")


On Fri, 10 Sep 2004 18:42:04 -0400, "Dennis Allen"
wrote:

Hi. In a date column, if I leave the cell empty nothing is displayed. If I

add a formula =IF(B40,B4+180,0), however, I get
1/0/1900. Question. Is there any way to surpress 1/0/1900? If there's no

value, I want to see an empty cell. Thanks for any
advice...Dennis