Answered by : arrogant-ant-cbr4cn3yoets

Sub rounding()
ActiveCell.Select Selection.Value = Format(ActiveCell, "#.00")
End Sub

Source : https://www.mrexcel.com/board/threads/formatting-data-to-2-decimal-places-in-vba.407349/ | Last Update : Mon, 06 Jul 20