ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pasting data from Matlab to Microsoft Excel (https://www.excelbanter.com/excel-worksheet-functions/133230-pasting-data-matlab-microsoft-excel.html)

nt_artagnian

Pasting data from Matlab to Microsoft Excel
 
I am trying to paste data from Matlab to Excel
but decimal-place numbers are cut.
e.g MATLAB EXCEL
0.2 0
How can I take the whole of the number from MATLAB?

Teethless mama

Pasting data from Matlab to Microsoft Excel
 
Format cell as General

"nt_artagnian" wrote:

I am trying to paste data from Matlab to Excel
but decimal-place numbers are cut.
e.g MATLAB EXCEL
0.2 0
How can I take the whole of the number from MATLAB?


nt_artagnian[_2_]

Pasting data from Matlab to Microsoft Excel
 
It does not work.
I ve done the Format-Cells-Number-2 Decimal Places
for the column. After I have paste the data and it does not work.

"Teethless mama" wrote:

Format cell as General

"nt_artagnian" wrote:

I am trying to paste data from Matlab to Excel
but decimal-place numbers are cut.
e.g MATLAB EXCEL
0.2 0
How can I take the whole of the number from MATLAB?


Gord Dibben

Pasting data from Matlab to Microsoft Excel
 
What happens if you format as number and increase decimal places to 1 or 2 in
Excel?


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 10:53:05 -0800, nt_artagnian
wrote:

I am trying to paste data from Matlab to Excel
but decimal-place numbers are cut.
e.g MATLAB EXCEL
0.2 0
How can I take the whole of the number from MATLAB?



nt_artagnian[_2_]

Pasting data from Matlab to Microsoft Excel
 
It's ok. I 've got it. I must copy from the command window
and not from the array editor of Matlab to have the result I wanted.

"Gord Dibben" wrote:

What happens if you format as number and increase decimal places to 1 or 2 in
Excel?


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 10:53:05 -0800, nt_artagnian
wrote:

I am trying to paste data from Matlab to Excel
but decimal-place numbers are cut.
e.g MATLAB EXCEL
0.2 0
How can I take the whole of the number from MATLAB?




Gord Dibben

Pasting data from Matlab to Microsoft Excel
 
Thanks for letting us know your resolution.

One more for the google archives<g


Gord

On Sat, 3 Mar 2007 11:34:13 -0800, nt_artagnian
wrote:

It's ok. I 've got it. I must copy from the command window
and not from the array editor of Matlab to have the result I wanted.

"Gord Dibben" wrote:

What happens if you format as number and increase decimal places to 1 or 2 in
Excel?


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 10:53:05 -0800, nt_artagnian
wrote:

I am trying to paste data from Matlab to Excel
but decimal-place numbers are cut.
e.g MATLAB EXCEL
0.2 0
How can I take the whole of the number from MATLAB?






All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com