On Thu, 08 Sep 2005 09:01:29 +0200, Heinrich Bürgers wrote: > > > 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
If it's any help, I just tried this on 1.9.128 with cells set to 3 decimal places, and it came out fine with a simple paste. -- John [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
