number format millions

  1. C

    three number ratio and cell formatting

    I'm trying to find the ratio between three very small numbers: Mass of Nitrogen D1 = 1.00x10-4 Mass of Phosphorus E1 = 2.04x10-6 Mass of Chlorophyll F1 = 7.71x10-6 Total mass H1 = D1 + E1 + F1 = 1.10x10-4 I'm attempting to show whole numbers, but I'm not sure if it is feasible. The first...
  2. C

    Can I create a toolbar or button to apply a number format?

    I want to create a toolbar or a button that I can press to apply a custom number format (it's basically just putting the numbers into millions). Does this require VBA? I have basic VBA skills, so I would be willing to go that route, however I normally try to avoid putting VBA in spreadsheets I...

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