DataText to ColumnsNextNextColumn Data FormatDateMYD

Works for me with 9-2008 returning Sep-2008 formatted as custom mmm-yyyy


Gord Dibben MS Excel MVP

On Wed, 10 Sep 2008 03:10:05 -0700, John
wrote:

Does anyone know the formula which will convert numbers into months for
example:

9-2008 and I need Sep-2008 have tried changing the column into a Custom type
using mmm-yy but it completely changes the month and year. The data has been
taken from our company operation system which is SAP.

Thanks