Office Software Thread, Convert text column of dates to date values in Technical; Usually I faf around with dates, extracting the day value, month value, concatenate etc.
The once it's in a nice ...
17th June 2010, 10:51 AM #1
Convert text column of dates to date values
Usually I faf around with dates, extracting the day value, month value, concatenate etc.
The once it's in a nice format, it usually sticks as text instead of changing nicely to a date field (right aligned etc) Strangely it changes correctly when you click on a cell, then hit return.
Thats ok for a few cells, but not an entire SPL fixture list
Found this tip. Select the column of values (take your concatenated date string and paste as a value)
Bang - column formatted.
Data menu>Text to columns>Next>Next>Column Data Format>Date>DMY and Finish
By DaveP in forum General Chat
Last Post: 30th May 2013, 10:10 AM
By danIT in forum Web Development
Last Post: 27th January 2009, 05:21 PM
By timbo343 in forum Windows
Last Post: 22nd April 2008, 05:57 PM
Last Post: 4th June 2007, 10:10 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)