cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:

## Changing number of decimals in WRITEEXCEL function  5-Regular Member

## Changing number of decimals in WRITEEXCEL function

Hi,

I am writing a large matrix to excel and I try  to change the number of decimals it is writing to excel.

I use the WRITEEXCEL function.

Is is possible to change the number of decimals before writing to excel?

1 ACCEPTED SOLUTION

Accepted Solutions  2-Guest
(To:jvandenbrink)

As for the poster's original question, you still need to round/truncate the "extra" decimal points using a formula. However, this is a simple formula of =ROUND(,) that is not extremely computationally expensive Prepaid Card Status.

7 REPLIES 7  20-Turquoise
(To:jvandenbrink)

Hi,

Yes it is possible to use the "round()" function on a matrix of numbers before the writing to excel.

With no round statement.  With the round function.  Cheers

Terry  5-Regular Member
(To:terryhendicott)

Hello terryhendicott,

Thanks a lot for your help. So in order to round a large matrix, I have to use some for loops to go through that matrix.

Looking at your example I still see that 15 decimals are exported to excel... A solution for this is to set the cell format in excel to 2 decimals for example, but then I have to perform this action every time I have exported data from Mathcad.

Is is possible to only send two decimal values to excel?  20-Turquoise
(To:jvandenbrink)

Hi,

"So in order to round a large matrix, I have to use some for loops to go through that matrix. "

Yes the round function can be applied to a vector all at once so you loop through the columns of the matrix. "Looking at your example I still see that 15 decimals are exported to excel... A solution for this is to set the cell format in excel to 2 decimals for example, but then I have to perform this action every time I have exported data from Mathcad.

Is is possible to only send two decimal values to excel?"

It does only send two decimals to excel.  I formatted excel to show 15 decimal places. This is how excel shows without formatting straight after transfer. Cheers

Terry  23-Emerald II
(To:terryhendicott)

Why not vectorize?  Success!
Luc  2-Guest
(To:jvandenbrink)

As for the poster's original question, you still need to round/truncate the "extra" decimal points using a formula. However, this is a simple formula of =ROUND(,) that is not extremely computationally expensive Prepaid Card Status.  23-Emerald II
(To:Cambages)

There should be no need to use the ROUND function within excel. You can just set the number of displayed decimals in the number formatting section of excel: Success!
Luc  5-Regular Member
(To:LucMeekes)

Hi Luc, 