This can be done using Format, as in:

ComboBox1.AddItem Format(Range("A1"), "#,##0.00")

or something to that effect.

HTH

"Ed P" wrote in message
...
Can anyone tell me how to make a combobox recognize comma's within number
strings. I have the linkedcells formatted as numbers and currency but the
display of the combobox will not show the comma's making large numbers
hard
to read.
Thank you in advance for your help.
Ed