Format of array pasted in CSV file

[xodus8]

I am pasting an array into a non empty .csv file using the following code

[C2].Resize(UBound(reformat_mat), UBound(Application.Transpose(reformat_mat))) = reformat_mat

We are losing some decimal places in the process (#'s in array have more decimals than #'s pasted into the .csv file).

How can I preserve all decimal places?

 

[Norie]

Isn't that code pasting into an Excel worksheet?

Perhaps you are losing the decimal places when saving as CSV?

 

[xodus8]

When I tried to save as a xls file it retained all the decimal places. So clearly the decimals are being lost when saving the file as a csv type. The current array is coming from a csv file as, how can I preserve all the decimal places when saving it as a csv file.