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:
CalculationsSheet is the name of the sheet,Please Login or Register to view this content.
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
Bookmarks