Skip to main content
16-Pearl
October 21, 2022
Solved

Significant Digits in Tables

  • October 21, 2022
  • 1 reply
  • 2449 views

How do I increase the number of significant digits displayed in tables.  The default seems to be 4.  I want to see 12.  2.9857555555 is displayed as 2.986.

 

Thanks

Best answer by Werner_E

You should have stated that you were talking about good old real Mathcad and not about the current (Mathcad) Prime! Tables in Prime are something completely different than tables in real Mathcad.

EDIT: Just saw that you added this information while I wrote this reply, but in the meanwhile I could tell that from your attachment in your second posting that you are using real Mathcad and not Prime (good choice).

 

To format the number of decimals shown in a Mathcad table, you right click the table,

Werner_E_0-1666432156730.png

select "Properties" and now you can format how the numbers should be displayed

Werner_E_1-1666432261784.png

According the (from my experience lame and instable) Excel component, the number of decimals has to be set in Excel (when you double click the table an Excel window opens).

Deleting rows in Excel does not change the number of rows which are transferred to Mathcad. You set the range to be transferred by right clicking the table in Mathcad, select "Properties" and in the "Outputs" tab you can change the range to be transferred to Mathcad. For the picture I deleted three rows (1703-1705) in Excel and so I changed the number of the last row to be used from 299 to 296. Now the number of rows of the Mathcad vector changes accordingly.

Werner_E_2-1666433050886.png

 

 

1 reply

25-Diamond I
October 21, 2022

You sure are nor really talking about tables, because tables show the values exactly as you typed it in

Werner_E_0-1666394231733.png

What you mean probably is the display of matrices and vectors, correct?

Werner_E_1-1666394297751.png

Here the same rules apply as for normal scalar variables.

You can set the way a result is display using the "Math Formatting" - "Results" menu

Werner_E_2-1666394437083.png

As usual you can set the format for one single expression or for the whole worksheet.

 

 

regcurry16-PearlAuthor
16-Pearl
October 22, 2022

Not if it is a data input table from the insert menu.

 

I am trying to have an input table (not a reference to an external file) where I can change digits in the 12th place and see the change.  Data Input Tables will not do that.  So, I am trying to do it through an Excel Component Input.  I can change the cell values; however, I cannot delete rows.  If I delete rows, the result still thinks it has the original 295 rows.  I have attached an example worksheet that I copied from QuickSheets.  I cannot even figure out how the author created this Excel Component Input, especially how he defined the cell ranges for the two output variable.

Any help is appreciated.

Reg

 

regcurry16-PearlAuthor
16-Pearl
October 22, 2022

Forgot to note I am using MATHCAD 15 only.