format cell date text

  1. K

    display complete dates as numbers and incomplete as text in same column

    Hello everyone, I am trying to format dates and am having trouble. I have a series of birthdates, most of them are complete and are in mm/dd/yyyy, but some are missing the day. Complete date - 01/30/2018 Incomplete date - 01/00/2018 I am having trouble getting excel to display the dates...
  2. S

    VBA Code Help

    I need help writing VBA Code that will work for a spreadsheet I am working on. I have tried the record macro process but I cannot get a date column I am working with the format correctly. This data is coming from a program and needs to be scrubbed so formulas can be written for it. In column...
  3. C

    Joining two pieces of VBA Code. Formatting a column to Date Format

    Joining two pieces of VBA Code. Formatting a column to Date Format Hi all. I hope you are well. I have two pieces of code that work and function correctly. The first piece of code essentially executes a Vlookup of three columns using a unique identifier from one sheet and puts them into...
  4. 3

    Formating text and Date on a cell.

    Hi there guys, quick questions here, I am sure its not difficoult. I am trying to average some events duration, however the cell is formated in general likes this: 0 Hrs 00 Mins 00 Secs (all in text) How could I be able to format that in order to be able to add two cells together or averages...

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