concatenating months and years

[Xtopher]

G'Day,

Please refer to the attached screenshot of my working spreadsheet.

I'm attempting to concatenate lines 86 and 87, month and year together.

The formula I use is: "=C86 & C87" - but I get a large number instead of "October 2009"

Any help with this would be greatly appreciated

[roli001]

Try:

=concatenate(C86," ",C87)

[Xtopher]

Sorry roli, this still returns a number for the month.

The year displays as 2009.

[Evagrius]

Hi - Try this,

Please Login or Register  to view this content.

[Xtopher]

Thank you for your replies.

daddylonglegs inadvertantly answered this one for me earlier;

Please Login or Register  to view this content.

Regards,
Xtopher