Oh hey, I just dealt with that a few weeks ago, too! If you're using OOO
Data -> "Text to Columns", after you've set the data type for an entire
column ("Format"->"Cells")On Thu, Dec 13, 2012 at 2:55 PM, Rich Shepard <[email protected]>wrote: > On Thu, 13 Dec 2012, wes wrote: > > > another thought has occurred to me... if this is a one-time deal, you may > > be able to just load it into Calc. there might be an option under > > right-click -> format cells to change the date format. > > wes, > > That's what I tried first. For a reason I haven't figured out, LO puts a > leading ' on that field and won't let me format the cells as > date/YYYY-MM-DD. I've done this with other data files but it just would not > work on this one. > > Thanks, > > Rich > > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug > _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
