When I export data to excel, excel appears to add additional decimals, whereas exporting to a csv preserves the data. Converting the csv to an excel file also preserves the data.
For example, one observation in stata (and in the raw data source) has the value: 310.744. When this observation is exported to excel it becomes: 310.743988037109.
If I outsheet to a csv it stays as 310.744 and if I save that csv as an excel file it still remains at 310.744.
Is there anyway I can get excel not to change my data?
Thanks
For example, one observation in stata (and in the raw data source) has the value: 310.744. When this observation is exported to excel it becomes: 310.743988037109.
If I outsheet to a csv it stays as 310.744 and if I save that csv as an excel file it still remains at 310.744.
Is there anyway I can get excel not to change my data?
Thanks
Comment