how to prevent matlab to rounding numbers during excel read

3 ビュー (過去 30 日間)
Surendra Sharma
Surendra Sharma 2017 年 7 月 3 日
編集済み: Stephen23 2017 年 7 月 3 日
I am reading this value 702438.0482 from excel but Matlab reading it as 7.0247e+05. How can I get original value i.e. 702438.482
  1 件のコメント
Stephen23
Stephen23 2017 年 7 月 3 日
編集済み: Stephen23 2017 年 7 月 3 日
@Surendra Sharma: do not confuse the value that is stored in memory and the value that is displayed in the command window. These are two quite different things.

サインインしてコメントする。

回答 (1 件)

John D'Errico
John D'Errico 2017 年 7 月 3 日
MATLAB did NOT round the number. You misunderstand the difference between how MATLAB displays a number, and what is stored.
help format
My preference is usually short g, because I don't want to see long strings of digits. But in order to see the full details
format long g
is usually best.

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by