16th

  1. P

    copy/paste 16 digit number

    When pasting numbers Excel converts any digits after 15 digits to "0" so 1234567812345678 becomes 1234567812345670 I need to cut and paste from an email. Is there a way to paste so the 16th digit shows correctly (without going manual) Perhaps with a auto prefix of comma? Thanks
  2. B

    If date 15th or less, show beginning of month, if 16th or greater, show beginning of next month

    Hi There, Working on warranties for products and need to determine if it should start the beginning of that month, or beginning of next month. We consider the 1st-15th would be that month, 16th to EOM would be Next month: So... 8/17/18 = 9/1/18 8/14/18 = 8/1/18 8/7/18 = 8/1/18 9/7/18 =...
  3. T

    Excel Timeline Chart

    Hi All, Having a little trouble, trying to create a line chart based on dates and sum. I've created a pivot chart to group all the same dates and sum them together per person. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Sum of Amount Column Labels Row Labels Q...

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