Assuming the data are in column A. Insert a column next to the data. Add the formula =value(a1). Fill down. Copy the result. 'paste special' back into the same location, but uncheck 'formulas'. tc
________________________________ From: Eustace <[email protected]> To: [email protected] Sent: Thu, June 9, 2011 7:48:31 AM Subject: [users] Pasting numbers in Calc 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 -- It ain't THAT, babe! - A radical reinterpretation https://files.nyu.edu/emf202/public/bd/itaintmebabe.html -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
