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
Bookmarks