bothered

  1. R

    Can I auto convert an entry of digits to time format?

    Here's a weird one. Due to the sheer laziness of some team members, they want to enter "1730" into a cell and have it convert to "17:30" Likewise, "530" would convert to "05:30" (5:30AM) I'm literally rolling my eyes because they can't be bothered to just physically write "05:30" (and yes...
  2. rhino4eva

    Inserting the filename of a file i have opened

    I know this is a little strange but....... I recorded a macro to input a txt file into a worksheet it only comprises of two columns starting in A1 I would like to be able to insert the filename (automatically) that I have used into c1 not bothered about the path just the name. I have used the...
  3. N

    Showing a record if it has a certain label

    Hi all, I have a sheet with a list of URNs (Unique Reference Numbers) on one worksheet. Each URN has a 'status'. On another sheet entirely, I want to be able to lift the URNs with a set status of 'Completeness and Authenticity Checks'. If the status is anything else, I am not bothered. Does...

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