date & time format

Hi, I have a database which cannot be changed. When I extract all the data out there are several fields in date format. However over the time it has been populated into about 5 different date formats from DD/MM/YY to MM/DD/YY to the aforementioned with the time after it etc etc. I was...

Good morning - I have a column of data containing dates that are entered as mm-ddd-yy. I have attempted to convert the format to mm/dd/yyy, but it appears the cell contents are being treated as text, and won't convert properly because Excel doesn't know if the year should be 19XX or 20XX...

Hello Guys I've tried and tried ... Searched and searched but couldn't find a solution.. So asking here to the experts... <tbody> A B 2016-02-2413:40:31 2/24/16 1:40 PM 2016-02-2413:36:05 <tbody> 2/24/16 1:36 PM </tbody> 2016-02-2413:40:08 2/24/16 1:40 PM 2016-02-2413:40:09...

Hi All, Apologies if this question is about I did search but could not find anything that could help me. First off I am new to the forums and after taking a brief look, it seems to be a great place to get excel knowledge/tips. Explanation/Question: I have a fairly large data extract I do...

When I create a query using Power Query (Excel 2016) and try to pull data from a table from a password protected workbook (already opened) there is always an error in the date column (whith any date format data) and plain numbers appear instead of the date in the outcome. I've tried this with...

Hello, I have in column C a long list of date and time in the following format: <tbody> 01/05@0558 </tbody> Where 01/05 is the date and 0558 are the 5:58 AM How can I split the format in two different columns and with the correct date (mm/dd/yyyy) and time (hh:mm) notation? Thank you so...