Swap the order. You first need to define the correct type of data for that column (format cells), THEN "Text to Columns", which basically casts the value, if possible.
On Thu, Dec 13, 2012 at 3:09 PM, Rich Shepard <[email protected]>wrote: > On Thu, 13 Dec 2012, Scott Bigelow wrote: > > > 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") > > Scott, > > I replaced OO.o with LO a while back. Regardless, I just tried your > suggestion and it's not working. The 'text to columns' removes the leading > single quote, then formatting the cells (after highlighting the entire > column) puts it back. Sigh. > > 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
