Thanks TMS, that makes sense.
Just so i'm on the right page, am I formatting the cell before, after or both when copying the values:
ws3.Cells(x, "B").Value = ws3.Cells(x, "B").Value & " " & ws1.Cells(y, "F")
I also assume I would be using something like this to format the cell:
Format(ws3.cells(x,"B", "Long Time")