ComboBox properties---need to recognize comma's in numgers
 

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

ComboBox properties---need to recognize comma's in numgers
 

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

ComboBox properties---need to recognize comma's in numgers
 

Ed,

How are you loading the combobox.

Try loading the text value, such as

With Me.Combobox1
.Additem Activesheet.Range("A1").Text
'etc
End WIth

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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