Suppose you are looking at a worksheet which contains dates which can't be formatted as 'real' dates because of their structure.1. Select the date(s), and use Data tab, Text-to-Columns
2. This brings up the Text-to-Columns wizard even though the dates are fixed width, in this case you can simply click Next twice
3. Select date (year, month, day)
4. Click Finish
Excel has provided me with endless problems in terms of widespread integration when taking over my current role as a network support technician. The company that I work for is currently rapidly expanding and we needed to put into place a lot of organisational features in an incredibly short time, it's been rediculously stressful. Thanks for the tip!
ReplyDelete-The rantings of a network support technie