Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

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

st: Conversion from string to numeric with imported excel document

From   Hans Lundin <>
Subject   st: Conversion from string to numeric with imported excel document
Date   Wed, 3 Oct 2012 13:34:41 +0200

I´ve also had numerous issues with conversion of Excel-sheets containing
string variables. If you have to import Excel-sheets more than occasionally,
my suggestion is to get the program StatTransfer. You can then decide the
storage format for each variable before the conversion. That has solved most
conversion problems for me.

Best regards Hans Lundin

2012/10/3 Ryan Stevens <>
> Hello all,
> I'm having a very weird problem. I have imported an excel document
> which was generated from an online game me and my co-author are
> working with. Of course, when importing it into STATA the numeric
> values are stored as strings. However, in trying to convert from
> strings to numerics, it changes the values of the cells. I have tried
> both encode and destring commands. I also attempted to trim off any
> blank spaces, believing this may be an issue. Furthermore, I've tried
> manually removing any blank spaces or non-numeric values from the
> excel file and re-importing the document, and I still have the same
> problem. The odd thing is if I am looking at any given cell it will be
> the right value, however, when I click on the cell and view the value
> of the number at the top, it does not match what is showing in the
> specific cell. Any thoughts on how to resolve this problem would be
> greatly appreciated.
> Best,
> Ryan
> *
> *   For searches and help try:
> *
> *
> *

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index