Problem after copying and pasting numbers in Excel

Question

Hello ,

I have a problem in Excel after copying and pasting numbers that are larger than 1 and contains comma or point

For example:

If I copied a number from MATLAB to Excel (let us say 0.9043)

It will appear in Excel correctly like this:

However, If I copied a number bigger than 1 from MATLAB .. (let us say 7.1406)

It will appear in Excel wrongly without the comma like this:

Any suggestions on how to solve this problem!

Answer 1

Which reginal settings do you have?
I have German settings, where the comma is the decimal separator and the dot the thousand separator.
If I copy your values to MS Excel, I get the same result because Excel interprets the dot as thousand separator and ignores it => value gets up in the million range.
Copy the value to Notepad & replace dot with comma; works for me.

Answer 2

yes, I did that and there is no issue after copying that to Notepad, but as you can see in Excel, the the comma (which is dot here) does not appear after the first number