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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

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

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
21-Topaz I
(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?

21-Topaz I
(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 III
(To:terryhendicott)

Why not vectorize?

Success!
Luc

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 III
(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,

That method doesn't work, since Mathcad is overwriting the cell format in excel.

The round function does work:)

Announcements
Top Tags