Microsoft Office Forums - View Single Post - [Solved] Date problem in excel 2007

Thread: [Solved] Date problem in excel 2007

View Single Post

Old

06-12-2012, 04:40 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 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