File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Zero in the cell instead of some junk date
Joined: Apr 06, 2003
Mar 08, 2006 14:30:00
Plz let me know how can I get zero in a cell whose format is set to a date format
C3 K3 I3
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:
subject: Zero in the cell instead of some junk date
convert date to date
Regular Expression help
Safari - Hex to Date Conversion
Regarding multiple IF's using "OR"
Date comparision in SQL from timestamp
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015