"the value shown in variable when i open it 3.5372"
The value is shown as such i.e. 4 digits after decimal, as it is the default output display format, 'short', for numeric datatype in MATLAB.
"the value shown when i print it is 3.53719758987427"
How exactly do you print it? This is not the 'long' format as it has 14 digits after decimal. Or did you missed a digit in copy pasting?
"but when i print the value i shows more decimal places than the actual value."
You have it the other way around. The floating point number is stored with (approximately) 16 digit precision but the default format (as mentioned above) displays only 4 digits after the decimal.
"How can i get the exact same value as it is in the excel sheet?"
If you want to obtain that in numeric format, it is not possible. You can, however, obtain that in text format -
format long
x = pi
sprintf('%0.8f', x)
sprintf("%0.8f", x)
You can round a number upto 8 digits after decimal, but the output will not exactly be same as what you want.
round(x,8)
