cell format

  1. S

    Add an ending zero to a bunch of numbers

    I am trying to add a zero to the end of a series of numbers. I have a list of 20,000 customer numbers, some with 5 digits and some with 6 digits. Example some are 123456 and some are 12345. I need to make them all 6 digits long, so I decided to add a leading zero to them. I made a custom format...
  2. O

    sort numbers which have dashes

    I need to be able to sort numbers of the following format:1-1,1-2,1-3,2-1,2-2,2-3,etc. Excel is not happy with this. I first have to format the cell as text just to keep excel from reformatting my numbers as dates, but then it doesn't allow me to sort them correctly. Help me please.

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