Julia Spies wrote:
thanks to everyone for the suggestions!
@Svend: The language settings actually appear to be the problem. However,
changing them afterwards does not solve the problem, since switching to
english makes the data appear like in stata before (cut decimal places).
Stata/Transfer does the job perfectly. Since i don't possess it myself i
thought there would be a way around...but well, next time, i can change the
language settings in windows before collecting the data, things should work
out then.
--------------------------------------------------------------------------------
Have you considered using -odbc- to load the values directly into Stata from
the Excel workbook? I'm guessing that in Excel the underlying numerical
value is stored identically regardless of display, just as for Stata. If my
guess is correct, then the ODBC route ought not to be affected by regional
settings.
Take a look at http://www.ats.ucla.edu/stat/Stata/faq/odbc.htm for tips on
how to use -odbc- with Excel.
Joseph Coveney
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
