custom number formatting

  1. B

    Pivot Table, Format Days Grouped into Weeks as "mmm-dd" of the First Day of that Week

    Originally posted on Excel Forum, but I haven't had any responses so posting to OzGrid and MrExcel. My data has these headers: Date, Customer, User, MyNumber The MyNumber column shows the number of things (doesn't matter, that's not the real header) that the User has for that specific date...
    • bpiereder
    • Thread
    • custom number formatting group dates mynumber pivot week
    • Replies: 1
    • Forum: Excel Questions
  2. T

    Custom number format works in pc, not on colleague's PC - error message inside

    I'm trying to use a custom number format to switch between K and M, depending on the number of digits. Here's the format I have: [>=1000000] #.0,," M";[>=1000] 0.0, " K";0 When I use this on my PC, it applies the formatting correctly. When my colleague tries the same formatting, the below error...
  3. C

    Urgent excel number formatting help

    Hi all, Im having an issue formatting telephones basically I've a large list of mobile and landline numbers in different formatted e.g some are 0741 1088291 others are 07 411 088 291 and more I need them to be 07411 088291 and the same with land lines. I have used different variations of...
    • Cdunlo11
    • Thread
    • custom number formatting excel formatting number formatting
    • Replies: 7
    • Forum: Excel Questions

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