> > bg:
> >
> > Doesn't work. Whether I enter it as =DATEVALUE($CELL)
> > or as =DATEVALUE($THEDATECELL) it still echoes " #NAME? "
> > all the way through to the final paste. What am I doing wrong?
> >
> > Brewster
Gene Young wrote:
> Try substituting the actual cell reference in place of "THEDATECELL"
> eg; =DATEVALUE($E5) where cell E5 is the cell that contains the date.
>
> Gene
bg:
Silly me. Shows how seldom I've ever had to delve this far into Calc,
doesn't it? I didn't get that Adam was expressing a reference. I just
so seldom need to dick around with any sort of formulas in cells.
So I tried it as you describe.
Got a "522" error msg. ("iteration", it says - and even after reading
the description I am not certain how it applies to this case.)
I sent a sample of the file at Richard Detwiler's request. Maybe
it will reveal its secrets :-)
Thanks,
Brewster
--
***********************************************************************
Embrace a sharing community of sustainable justice low-carbon diversity
***********************************************************************
W. Brewster Gillett [email protected] Portland, OR USA
***********************************************************************
Simply because you don't like to hear it, that doesn't make it untrue.
***********************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
