Importing Data



Gnumeric version: 1.5.9.0 on Windows XP.

I'm trying to import accounting data from company reports (like the
SEC 10-K's, 10-Q's), and not having much luck.

The closest I have been able to come to success is to edit the section
of the original that I am interested in, by inserting ';'s as
seperators between the columns of data, and then selecting paste. This
does, pretty much, get the numeric data in the right column. However,
the pasting operation seems to regard the ',' in the numbers as a
decimal point, so that the number $691,066 is turned into $691.00,
quite a difference.

I've tried changing the column type from general to accounting, etc.,
but the truncation occurs no matter what.

In general, what is the best way to import this sort of thing into
gnumeric?

Thanks for any advice,
Scott
-- 
sdb ssr com



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]