View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Converting Numbers to Months

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