File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Zero in the cell instead of some junk date