cell functions

  1. N

    How do I force a comma between two 4 digit numbers?

    I want to put a comma between two numbers in a cell without a space, for example: 3055,2666 I tried using the custom cell format to force the separation but it didn't work. The comma keeps on separating the numbers into 30,255,666 Any ideas?
  2. T

    Change cell contents based on other contidions

    If the stock numbers are the same in column A, and in one of the corresponding status codes in column B there is an S (in that same series of same stock numbers), then I want a "Y" in column C, otherwise I just want the contents of column B in column C. There can be 1 to 9 stock numbers that are...

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