[VBA] rounding off to 2 decimal places in excel maco

[Planar1280]

If a totals or numbers in excel are coming in as 4.236. How do we code it in VBA in excel macro so that it rounds to 4.24?

[C:Amie]

FormatNumber(4.236, 2)

[Planar1280]

  On 26/05/2011 at 17:22, C:Amie said:

FormatNumber(4.236, 2)

If it is any number like 1.236 or 121.877?

[Kami-]

Dim x As Long

x = 4.236

Debug.Print (Round(x, 2))

;)