On Tue, 2011-03-29 at 06:19 -0700, tinu_mury wrote: > I don't know if you solved it yet, but there is an easy way to eliminate that > ' character from the spreadsheet. > Insert a new column next to the one you want to work with and use the > "=value()" command. > For example: in column A cell 1 you have '2346, in column cell 1 enter: > =value(A1) > This will copy only the numbers from that cell. > > This worked fine for me and I hope it will be useful for others.
Presumably in your fifth line, above, near the right end, where you say, in column cell 1 enter you meant to write, "in column B cell one". Brewster -- *********************************************************************** Embrace a sharing community of sustainable justice low-carbon diversity *********************************************************************** W. Brewster Gillett b...@fdi.us Portland, OR USA *********************************************************************** Simply because you don't like to hear it, that doesn't make it untrue. *********************************************************************** -- ------------------------------------------------------------------------ To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help