# How to round numbers in tables?

162 views (last 30 days)
Hao Tang on 22 Feb 2018
Commented: the cyclist on 2 Oct 2021
How can I round a number in a matlab table after it does its calculation? I have a cell that calculates the value to be 0.009999998 but I want it to read 0.01. I tried using format short g in the script but that didn't work.

the cyclist on 22 Feb 2018
Edited: the cyclist on 22 Feb 2018
Use the round function.
You could have discovered this for yourself by typing
docsearch round
in the MATLAB command window, or typing
round matlab
Note that there is a difference between the value that is calculated/stored, and how it is displayed. The format command is about the display.
##### 2 CommentsShowHide 1 older comment
the cyclist on 2 Oct 2021
See my comment on your "answer" below.

Star Strider on 22 Feb 2018
If you do not have the R2015a (I believe that is the correct release) that introduced the new round function, this anonymous function emulates it:
roundn = @(x,n) round(x .* 10.^n)./10.^n; % Round ‘x’ To ‘n’ Digits, Emulates Latest ‘round’ Function
x = 0.009999998;
xr = roundn(x,2)
xr =
0.01
Lance Yarbrough on 14 Apr 2019
Edited: Lance Yarbrough on 14 Apr 2019
THANK YOU!! Looking for this answer forr most of the DAY.

Bill Tubbs on 2 Oct 2021
Is here a way to use the round function with tables?
Simply using round(my_table, 3) does not work:
t = array2table(randn(3, 4), 'VariableNames', {'A', 'B', 'C', 'D'}, ...
'RowNames', {'1', '2', '3'});
round(t, 3)
Output:
Error using round
First argument must be a numeric, logical, or char array.
I found this solution but it's quite convoluted:
t2 = t; t2{:, :} = round(t.Variables, 3)
Output:
t2 =
3×4 table
A B C D
______ ______ ______ ______
1 0.722 0.187 -0.439 -0.888
2 2.585 -0.082 -1.795 0.1
3 -0.667 -1.933 0.84 -0.545
Surely there is a better way...
the cyclist on 2 Oct 2021
OK. I can't tell from this comment whether you ended up with a solution that works for you.
If not, you might want to start a new question with your specific needs, rather than commenting and "answering" on an older question. You'll typically get more eyes on it if you do.