This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 81%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
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!
Just for a test, can you copy the "bigger" figure from MatLab to a Texteditor like Notepad to see the raw data stored in clipboard?
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.
I have the Dutch regional settings which I assume that it is similar to the German one.
However, I replaced the dot in Notepad with comma and then copied the numbers to Excel.
That's partially solved the problem as I can see the numbers correctly now but Excel will consider them as a text because if I summed up these numbers, the results will be zero
Thanks for your help!
I can convert the text to numbers and that's will solve the problems!
Right. There is a green rectangle in the upper left corner, which means the cell is formatted as text, but Excel recognice a numeric value. You can let Excel convert it to a real numeric.
Thanks!
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
