清空筛选条件
清空筛选条件

Imported data becomes combination of number and alphabet for 1 decimal places value

1 次查看（过去 30 天）
PANG
PANG 2023-12-8
回答： Dyuman Joshi 2023-12-8
i am new to matlab and i want to import the dataset for my final year project. in the original excel file, i have a data called Pressure MSL (Hpa) and some of the values are shown in the first image. when i imported the excel to matlab, it becomes some combination of numbers and alphabet and says "1.0118e+03 Converted to [Type: Number, Value: 1011.8]", just like shown in the second image. How can i show the original value of 1011.8 instead of 1.0118e+03? is there any setting or command to fix this?

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

回答（1 个）

Dyuman Joshi
Dyuman Joshi 2023-12-8
Ran in:
Change the display format -
y = 1011.8
y = 1.0118e+03
format longG
y
y =
1011.8
Note that this only changes how a numeric value is displayed, not how it is stored by MATLAB.
Also, the combination of numbers and the alphabet e is known as the Scientific notation.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by