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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
Similar Threads
Regarding multiple IF's using "OR"
convert date to date
Regular Expression help
Safari - Hex to Date Conversion
Date comparision in SQL from timestamp