sig-figs

  1. M

    Issues with 3 sig figs VBA code

    Thank you for your help in advance! I have this macro to update significant figures that has been working great for some time, but recently we unlocked a spreadsheet to copy/paste data into a new program and we noticed that not all of the values are being actually truncated to the 3 sig figs we...
  2. E

    Limiting a VBA variable's significant figures

    I'm working with a code currently, and the calculations are coming out with WAY more sig figs than I need. Is there any way to limit the sig figs of a specific "variable" in VBA? For instance, r1 is the first root from the quadratic equation for a given polynomial, based on coefficients a, b and...
  3. G

    Format for Sig-Figs

    When I create reports at work, I seem to be constantly adjusting the number of digits after the decimal point. What I really want is, say, three significant figures, whether they be 0.123, 1.23, 1230, or whatever. Is there a way I can tell Excel to give me as many decimal places as it takes to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top