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


--
Simon205
------------------------------------------------------------------------
Simon205's Profile: http://www.excelforum.com/member.php...o&userid=34662
View this thread: http://www.excelforum.com/showthread...hreadid=544272