Prevent a month from appearing as a serial number

Hi

I am experiencing difficulties with a formula which displays the relevant month as a serial number.

I have a sheet which lists the names of staff members in column A and the date their work took place in column B. In order to calculate the month the work took place, column C displays the details of column B and has been custom formatted as 'mmmm'.

I now have a number of formulas which are required on a separate sheet and the first of these formulas requires the name of the staff member and the month their work took place. An example of this has been displayed in the sheet attached.

Test Sheet.xls

Using cell E3 as an example, to display the contents of cell A3 and C3, I have used the forumla '=A3&C3'; however, as oppose to appearing as DaveOctober, the cell displays Dave41192.

Is it possible for cell E3 to display DaveOctober?

Thanks

=A3&TEXT(C3,"mmmm")


Regards, TMS

You're welcome. Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save