a1=22

  1. B

    Converting into date format in excel

    I have selected three cells A1 = Day, B1= Month & C1=Year. Now I want to get date format in cell D1 as DD-MM-YYYY. For example, A1=22, B1=10, C1=1975 and the result will be in D1= 22-10-1975. How can I do that?
  2. I

    Run one code but mimic it on another two sheets

    Evening, I have 3 worksheets which are all identical. Currently as i type in certain cells on sheet1 the values are automatically updated in certain cells of the same sheet. What i would like to do is be able to enter the values in cells on sheet1 but also on the other to sheets copy me as i...
  3. R

    Whole #s as a result dividing by 3

    Hi All I want to divide a number by 3 and distribute it in whole numbers. I found examples online using a bucket and tennis balls but haven't been able to translate it. A1=22 tennis balls, and B,C,D are buckets of tennis distributed into whole numbers B1=8 C1=7 D1=7 Your help is greatly...

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