So I feel like this should be simple and I've tried multiple different ways of doing this but when I save the information in a text file it still pulls all of the numbers to the right of the decimal place even though it only shows 2 numbers to the right in excel. And the Round function in VBA isn't doing anything it just exits my code or does nothing.

So I've tried this

With ActiveSheet
    For R = 1 To .UsedRange.Rows.count
        .Cells(R, 5) = "=WorksheetFunction.Round(.Cells(R, 5), 2)"
    Next R
End With
as well as

With ActiveSheet
    For R = 1 To .UsedRange.Rows.count
        .Cells(R, 5).FormulaR1C1 = "=Round(RC(.Cells(R, 5)), 2)"
    Next R
End With
and this

ActiveSheet.Columns("E").NumberFormat = "0.00" 'or #.## neither works
it will show in the cell the number as 389.69 but when you click on it is still has every number beyond the decimal point 389.694864815648946. Does anyone know what I'm missing or is excel not capable of this? Thank you