How to convert a column with different date formats to a common date format?


0 votes
asked Mar 14, 2016 by Ceb9014Run (590 points)
Thanks for any help provided

4 Answers

0 votes
answered Jun 1, 2016 by theargus (540 points)
selected Jun 2, 2016 by gb885payna
 
Best answer
The code was downloaded from SQL Server Helper - Tips and Tricks - Date Formats help here would be really great
I think your requirement solution is too to customize the default keyboard
0 votes
answered Mar 21, 2016 by wisdom (400 points) 1 flag
Combine and Consolidate Multiple Sheets and Workbooks.
Select the range that you want to convert.
Then click OK, the number has been converted to normal Excel date. So you need to change the date format.
0 votes
answered Apr 1, 2016 by Pom_6394 (290 points)

Particularly if these dates have been imported from another program.
commented Apr 1, 2016 by Falckor (580 points)
Convert dates stored as text to normal Excel date with formulaAmazing
commented Apr 2, 2016 by peschel (320 points)
I thought that I might add this snippet to this old post
0 votes
answered Jun 1, 2016 by Zorman (440 points)
HintHow to be more efficient and save time when using Excel

What is Geekub?

Q&A site for professional and enthusiast programmers, software developers and other technical users. With your help, we hope to work together to build a library of detailed answers to just about any question that is related to programming!







...