Pasting the data from Excel to Stata converts values of the variable

[Neelakanda Krishna]

Dear Stata Members
I am dealing with some financial data like income, total assets, etc. Many of them are very big numbers for instance USD 25678998.567. Data is in the xls format and when I copy my variables and paste it in edit mode of Stata, many of those digits (values) are changed. How to preserve the original numbers including the decimal points before inputting data

[Joseph Coveney]

It might be due to Stata's default single-precision floating point numerical datatype, but you would probably be better off importing the data into Stata programmatically rather than a copy-and-paste approach to data transfer.

help import excel

for more information about how to do that.

[Neelakanda Krishna]

Dear Joseph Coveney , that works I think. Yes I shouldnt have pasted data which I often do

[bibha dhungel]

I have somewhat similar issue, when I copy-paste from Stata to excel, all other data is pasted fine except one row of observation which is pasted in two lines. Why is that so? I cannot upload my data here (data privacy) and I cannot replicate this issue in other data.
When I copy paste in excel, there is an extra comma I get:

Stata data viewer:

Here, study 55 is pasted in two lines. There is an extra tab with comma. I will use export excel to resolve this issue, but I am just curious to know what led to this.