date as text

  1. R

    How to clean up and format very messy date and non-date date

    Hello everyone, Big fan of the Mr. Excel forum, and first time posting. Thanks in advance for any advice! A small nonprofit that I am helping gave me a dataset that tracks their donations and I am trying to clean it up for them so we can run analytics. However, the dates for each row (1 row...
  2. M

    Find begining and end of a DATE range to extract

    Hi Everyone, I have been breaking my head around the way of extracting a date range in my excel sheet. Here are the requirements:- 1) My sheet contains 2 Columns ("Date" & "Product ID") and below is a sample set of records and their formats (sometimes I have multiple records with same...
  3. C

    Keep date as a number

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  4. S

    Date Format query

    Hi I have below data which generates in skewed date format some come with 4 digit year and some with 02 Digit year . I am also unable to convert the Date Text into date . Tried all your earlier tips . I am using Excel 2003 would you be able to help in converting all in an uniform format ...

Watch MrExcel Video

This Week's Hot Topics

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
Top