Greetings Excel/VBA Experts!

I am a Business Analyst in the IT department and our end users upload an Excel(2010) journal template into our PeopleSoft Financials system. However, when users paste data from other sources or from formulas the values end up extending beyond two decimal places. To support them, we were asked to limit the decimal places on the template. I am not very familiar with VBA and I'm in desperate need of assistance. I found the following code that should produce the results we require, but I can't get it to work. Please help! Any assistance that you could provide would be greatly appreciated.

Private Sub Worksheet_change(ByVal Target As Range)
If Application.WorksheetFunction.IsNumber(Target) Then
Target.Value = Round(Target.Value, 2)
End If
End Sub

We currently have other customized code to auto capitalize certain fields on the template. I am not sure if this code should be incorporated into the same code or placed elsewhere.

Thanking you in advance!