On 6/9/2011 10:45 PM, RA Brown wrote:
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
Why not just select the "Detect special numbers" box and let Calc do
its job?
Where is that box? A new feature of version 3.3 possibly?
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help