Dan Lewis wrote:
Do you first format the columns into which you are inserting data ?
usally: no
quick test: preformatting whole spreadsheet as "user-defined" turns out
in the same mess.
There is a possible second way. Try inserting the data as formatted
text. For example, everything in Column C contains numbers as text.
when trying to insert as formatted text (rtf) OO will paste everything
into column A, my tabs for cell-separation will be ignored.
Using the Value function, these can be converted to numbers in another
column (Column Q for example). Then set Q2= Value(C2) etc
check this out:
Raw Data
0.163 0.154 0.163 0.147 0.147 0.146 0.149 0.142 0.147
copy-> insert contents-> unformatted text-> tab-separated
all puncations will be gone
next test: replace all 0 by 1 and then do copy paste again. interesting
result!
next test: use something with two digits only:
0.16 0.15 0.16 0.14
works! why?
next test: replace 0 by 1
1.16 1.15 1.16 1.14
data appear as dates (very futuristic ones from 2016...). Any way to put
them back to 1.16?
I know this used to work with older versions where I was able to turn
autoformat off.
still puzzled- Heinrich
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
