Thread: [Solved] Date problem in excel 2007
View Single Post
 
Old 06-12-2012, 04:40 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Try this...
  • Select the column > Data > Text to Columns
  • Next
  • Next
  • In the column data format choose Date YMD
  • Finish
Reply With Quote