cell contents
=IF(A1="","",+A1)
--
CCO
"Candace" wrote:
I need cell B1 to show the same content as A1, which is a cell that holds a
date. Therefore I set the formula for cell B1 as "=A1". The problem is that
if I don't have a date entered in cell A1, B1 shows "1/0/00". Is there a way
for B1 not so show any content unless A1 has content?
|