Hi All,

I have a user form and on that form is a text box. Data from a cell on the worksheet is read into that text box and the user can observe it.

A simple calculation is done on the cell before it is read into the text box. This produces a number with a large number of decimal places. Even though I set the number of decimal places of that cell to 2 (via right clicking on the cell and selecting "Format Cells...") the number read into the text box still displays all the decimal places.

Could anyone tell me how I can set the number of decimal places of the text box itself?

Best Regards,

Aaron