Imported data becomes combination of number and alphabet for 1 decimal places value
조회 수: 3 (최근 30일)
이전 댓글 표시
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?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1563464/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1563469/image.png)
댓글 수: 0
답변 (1개)
Dyuman Joshi
2023년 12월 8일
y = 1011.8
format longG
y
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.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!