Hello

I am stuck with this problem. I have a command button in a userform. This button calls up a message box and in this message box it displays some text followed a number, which is linked to a cell in the spreadsheet that contains a mathematical formula. The number is displayed with 11 decimal places but I want the number to only show 2. How do I go about doing this?

Here is my code:


 MsgBox ("Results 1 = " & CalculationsSheet.Range("Calculation1").Value & vbNewLine & "Results 2 = " & CalculationsSheet.Range("Calculation2").Value)
CalculationsSheet is the name of the sheet,
Calculation1 is the name of the cell, this cell contains a formula

The above code is displaying the message box as follows:

Results 1 = 11546.85623145612
Results 2 = 556.87452114585

But I want the numbers to only have 2 numbers after the decimal place, i.e. Results 1 = 11546.86

Thanks