On 6/11/2011 7:35 AM, Don Daugherty wrote:
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?
It is available in the filter box that shows up when you double click on
a .csv file.
I do not know of any other way to get to that screen.
Joe Conner, Poulsbo, WA USA
--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help