On 2011-06-09 23:45 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?
Perfect! After posting the message I realized that the issue was a space
after the number, and that I had to find the spaces and replace them
with nothing, but this solution is much better. Thanks.
emf
--
It ain't THAT, babe! - A radical reinterpretation
https://files.nyu.edu/emf202/public/bd/itaintmebabe.html
--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
