Converting Date Format

[nickwood1066]

Hi,

Does anyone know how I can convert "201205" into "May - 2012"?

Do I have to concatenate?

Best regards

Nick

 

[VoG]

Try like this - format the result cell as Custom

mmmm - yyyy

Sheet2

*	A	B
1	201205	May - 2012

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:96px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B1 =DATE(LEFT(A1,4),RIGHT(A1,2),1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Andrew Poulsom]

To return a text entry you can use:

=TEXT(TEXT(A1&"01","0000-00-00")+0,"mmmm - yyyy")

To return a serial date you can use:

=TEXT(A1&"01","0000-00-00")+0

formatted as mmmm - yyyy.

 

[nickwood1066]

Great!! Both work! thank you for all your help - been struggling with this for a while!