In place with no formulas..............

DataText to ColumnsNextNextColumn Data FormatYMD and Finish.


Gord Dibben MS Excel MVP

On Wed, 28 Apr 2010 10:42:01 -0700, readystate
wrote:

I have a spreadsheet that contains a list of dates but they are formatted as
follows - 20100427. How would I go about converting those cells to a
standard format - 04/27/2010? Any help or suggestions would be appreciated.