aspose file tools*
The moose likes General Computing and the fly likes Zero in the cell instead of some junk date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "Zero in the cell instead of some junk date" Watch "Zero in the cell instead of some junk date" New topic
Author

Zero in the cell instead of some junk date

sunita shaw
Ranch Hand

Joined: Apr 06, 2003
Posts: 45
Plz let me know how can I get zero in a cell whose format is set to a date format

C3 K3 I3
System testing 10-Feb-06 11-Feb-06
e.g

IF(OR(C3="Test Planning",C3="Project Planning"),IF(K3<>"",K3,I3),0)

But here I get 00-Jan-00 if it dose not match...
How can i get a zero displayed
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Zero in the cell instead of some junk date