On Wed, 2010-09-22 at 10:04 -0700, Brewster Gillett wrote: > OOo 3.2 under Ubuntu 10.04
Hi, saw your post over on evolution@ :) > Here's what I have. 678-row Calc file, names & addresses and some > additional information. One of those is a column for "date on list". > Unfortunately the way I get the file, as a CSV, those entries are > not formatted specifically as dates, even though they all follow a > common format of MM/DD/YYYY. I note that each entry is preceded *in the > edit window*, but *not* in the cell itself, by a single quote. I believe > this single quote is a forced text format identifier of some sort. =DATEVALUE($CELL) will convert a text representation of a date to a date value. -- Adam Tauno Williams <[email protected]> LPIC-1, Novell CLA <http://www.whitemiceconsulting.com> OpenGroupware, Cyrus IMAPd, Postfix, OpenLDAP, Samba --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
