Hi,

Does anyone know how to ensure that a cell's text formatting properties carry through to the selected value in a combo box?

For example, if the combo box is linked to a cell with the value 400, with text suffix of "mm", how do I get the combo box to display "400mm" when selected?

Thanks for any help,

Simon

Excel 2000