# How I can modify the decimal numbers in a table's column?

48 views (last 30 days)
BN on 5 Aug 2021
Answered: Awais Saeed on 5 Aug 2021
I have a table with different values like: 0.5, -0.300, -99, 5, 0, and so on. I want to use the output of this table in a hydrological model so I need to have all values in 1 decimal (even integer values, like 5).
Here is an example:
-5.40000000000000
-2.20000000000000
-3.40000000000000
5
4
-99
0
Are what I have, But I need something like this:
-5.4
-2.2
-3.4
5.0
4.0
-99.0
0.0
I tried something like format long, format long g, and format bank, but they weren't helpful. So if anyone knows the solution I would be grateful if tells me.
Best regards

Chunru on 5 Aug 2021
a = randn(5,1)
a = 5×1
0.1370 -0.9759 -1.3119 2.0201 1.3604
str = sprintf('%.1f\n', a)
str =
'0.1 -1.0 -1.3 2.0 1.4 '

Awais Saeed on 5 Aug 2021
You want to display the numbers as shown or modify them? In case you want to modify them, you can use
number = -99.32345; % the number you want to modify
num_str = num2str(number); % convert it to string
[idx,~]=regexp(num_str,'[.]'); % search for decimal point
num_str(idx+2:end) = []; % delete everything from idx+2 till end
number = str2num(num_str) % convert result back to number
You can use this in a loop to modify all of your values.

### Categories

Find more on Logical in Help Center and File Exchange

R2020a

### Community Treasure Hunt

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

Start Hunting!

Translated by