ActiveCell.Offset(0, 11).Value = TextBox85.Value + 0 Range("L7:L" & Rows.Count).NumberFormat = "#,##0.00"