How can I get 3 decimals placeś ine the table?

15 views (last 30 days)
Hello, I'm new to matlab but and i want my numbers in the table to be fixed to 3 decimal places(right now i get something like 5,5182 e+6) here is my code
if true
% code
dane = xlsread('dane1.xlsx');
nr=['W1';'W2';'W3'];
A=dane(:,1);
B=dane(:,2);
C=dane(:,3);
D=dane(:,4);
app.UITable.Visible = 'on';
app.UITable.Data = [cellstr(nr) num2cell(A) num2cell(B) num2cell(C) num2cell(D)];

Accepted Answer

Nicolas Schmit
Nicolas Schmit on 5 Dec 2017
Set the column type to char, and use sprintf to format the numbers with the desired number of decimal places.
app.UITable.ColumnFormat = {'char'};
app.UITable.Data = {sprintf('%.3e', 1.2345678e-3)};
  1 Comment
Kamil Tomiak
Kamil Tomiak on 5 Dec 2017
well i used insted of e f to get fix number but it helped me! thanks! app.UITable.ColumnFormat = {'char'}; app.UITable.Data = {sprintf('%.3f', 1.2345678e-3)};

Sign in to comment.

More Answers (0)

Categories

Find more on Get Started with Statistics and Machine Learning Toolbox in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!