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

7 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)

Products

Community Treasure Hunt

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

Start Hunting!