Brewster Gillett wrote:
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
Spreadsheets are very complex and verstile tools. Somewhat like a
simplified programming language.
It is extremely simple to get something in and out of a sheet.
It can be extremely hard to get the right stuff in and out.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
