Convert scientific notation in table

Hi,

I create a table that looks like this:

How can I get rid of the scientifc notation in the last two columns? I want to create uitable using the struct or trable above.

Thanks.

[Benjamin Thompson]

Is this a table in Excel? If you import a text file into MATLAB, formatting does not matter because you can choose the display format later on. Can you post code or sample data?

See the article on uitable in the MATLAB documentation or "Table Properties" for how to use the uitable ColumnFormat property to control the display.

Answer 1

[Rahul]

Hi @Konvictus177,

I understand that you wish to adjust the notation of the data in your table. Considering you have obtained the table in your MATLAB workspace using the 'readtable' function. You can use the 'convertvars' function to adjust the data type of the desired columns according to your specifications.

Here is an example:

T1 = readtable('yourTableName.csv');

T2 = convertvars(T1,{'columnNameToChange'},'single');

% Here I have used random file and column names, you can adjust that accordingly.

% I have converted the data type of the column to 'single', however
% conversion to 'double', 'int8', 'int16', 'int32'	and many more are possible

You can refer to the following MathWorks documentations to know more:

'readtable': https://www.mathworks.com/help/releases/R2022a/matlab/ref/readtable.html

'convertvars': https://www.mathworks.com/help/releases/R2022a/matlab/ref/convertvars.html

Hope this helps! Thanks.