On Tuesday 06 September 2005 08:22 am, Heinrich Bürgers wrote:
> Ok,
> fist, I use 1.1.3 on a debian testing.
> standard procedure used to be: copy data from a text-like output
> (readonly) and insert the data into a spreadsheet by "Bearbeiten"
> (edit) -> insert Data -> unformatted text-> unicode, tabulator
> delimited (I think in english)
> data like 7.8 will be recognised as 01.07.80
> I am aware, that I could paste the data into vi, replace all points
> by commata, paste into Starcalc....
> But these autoformats affect other things, too: like gene-names or
> abbreviations.
> As user from older versions (from SO 4.1 on), I always simply ticked
> "Autoformat off" and was ahead of the guys struggling with MSOffice.
> I can't find the checkbox!
> And, when I open old datasets, my data will be converted, too, and I
> am not able to find out, how I can restore them!
> Because: selecting "format->cell->user-defined" will not give 7.8
> again, but 29403.
> ???
> thanx, Heinrich
Do you first format the columns into which you are inserting data ?
There is a possible second way. Try inserting the data as formatted
text. For example, everything in Column C contains numbers as text.
Using the Value function, these can be converted to numbers in another
column (Column Q for example). Then set Q2= Value(C2) etc.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
