On 6/9/2011 6:48 AM, Eustace wrote:
When copying from
http://www.invincibleamerica.org/tallies.html
the 4 columns and pasting them in Calc as Unformatted text separated
by Tab, the first column of numbers pastes with some code in the
beginning, so I have to double-click in each cell, then something that
resembles a ' (single quote) appears in front of the number, and
delete it.
If I try to copy and paste these ' in the search box to have it
replaced with nothing it does not find them.
How can I easily change the column to simple numbers?
emf
If this just started happening since the version number went from 3.2.1
to 3.0 or higher, it may be a feature of 3.0. I went back to 3.2.1 to
get rid of this very undesirable (for me at least) behavior. If you're
willing to introduce 4 new columns to paste the data into, and use
VALUE() formulas in the regular columns to get the values obscured by
the small apostrophes, you may be able to get satisfactory results.
Like you, I had no luck using Search/Replace to get rid of the apostrophes.
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
