Zero in the cell instead of some junk date
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
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
Re: Zero in the cell instead of some junk date
> But here I get 00-Jan-00 if it dose not match...
> How can i get a zero displayed
Try enclosing the zero with quotes, like "0"
Input as Text format by typing '0 directly in cell
Originally Posted by Bucky
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1