Changing from custom value to text format

Is it possible to change this code to a text format rather than a custom, which is what it returns right now.

HTML Code: 

Have you tried this:

 With Range("H4", Range("H" & Rows.Count).End(xlUp)).Offset(, 26)
        .NumberFormat = "00"
        .FormulaR1C1 = "=MONTH(EOMONTH(RC[-26],-3))"
        .Value = .Text
    End With