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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top