Here is the code that is outputting the formula rather than values.
Range("A2").Select
ActiveCell.FormulaR1C1 = "=concatenate(A3,IV1)"
However the following code is used in a different cell in the same spreadsheet and the values are output
Range("IV2").Select
ActiveCell.FormulaR1C1 = "=TEXT(R[-1]C,""yyyy-dd-mm"")"
Range("A1").Select
The element of the worksheet that is showing formulas rather than values has been copied from another workbook with the following code, could this be the reason?
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Thanks
Matt