text to date

  1. E

    Formula to convert into a valid date and time

    Hi Everyone, I have following dates that in excel column L and i need to convert all into a valid date and time format? <tbody> December 10, 2017 at 8:29:55 PM GMT January 30, 2018 at 7:37:48 AM GMT January 4, 2018 at 9:02:29 AM GMT February 8, 2018 at 12:02:29 AM GMT March 5, 2018 at...
  2. J

    Converting Date & Time Stamp to a useable format - need help!

    I'm trying to convert the following values into an excel friendly date value, time is irrelevant. If possible I'd like to retain the time value, everything I've tried so far though has failed. <colgroup><col></colgroup><tbody> Mar 22 2017 02:24 PM Jun 23 2014 12:40 PM Jan 11 2016 05:35 PM...
  3. A

    2007 text to date - entire sheet

    Hi, I have a data sheet which has one date column. I formatted the entire column to be in date format. Then, for some reason, I opened the sheet and got all the column as text. for examle: 30/04/2014 shows as 41759. i tried re-formatting the cells and the column, but nothing helps, it stills...
  4. S

    Help with imported data from ERP system - issues with leading zeros, text to date

    I just started at a new company and am having issues using the information I have pulled from our ERP system (SyteLine, which uses a SQL back end) into excel. The problem is the formatting of our sku's... there is no common part number format across all of our product lines. Some start...
  5. G

    Acess text field converts in number in excel spreadsheet

    Hi Mr Excel, i am trying to get data from Ms access to excel Spreadsheet. the table filed in acess is decleared as text and i have stored text,number and decimal(1.5) as well. but when it comes to excel spreadsheet decimal number converts into Date format(30-Dec-1899) automatically. below is...

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