Importing data from excel and losing precision

2013 12 12
1 个回答
回答已采纳
更新时间：2013 12 12
5 次查看（30 天）

0 个投票

I am importing data from excel, and it is only importing to the 3rd decimal place. I have tried formatting long to no avail, example: from excel 7.369487E-10 becomes 1.0e-09 * 0.737. Is it because of the E-10 that it will only import to this precision? When it is formatted long it shows 1.0e-09* .73700000000. It is an array that I am importing and I am comparing averages of the array in matlab and excel and they are not matching up for this reason, thanks

请先登录，再回答此问题。

 采纳的回答

Ryan Helling
Ryan Helling 2013-12-12

1 个投票

the problem was I was using xlsread on a csv file, once i changed the file back to a xlsx file i was able to retain all of the decimal places.

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by