Combo box number format query

[Brick]

I am using a combo box control in Excel and the Listfillrange for this combo box has numbers with the percentage format on, however in my spreadsheet when I use combo box the number shows as a percentage when dropped down but comes up as a decinal when shown in the spreadsheet.

Anyway to change this?

regards

Brick

 

[Juan Pablo González]

Are you using a Form Combobox ? or a Control combobox ? in other words, which toolbar are you using ?

 

[Brick]

I am using a control combo box.

 

[Juan Pablo González]

And are you using a LinkedCell ? does it have a % format ?

 

[Brick]

I am using a Listfillrange and the format has been changed to percentage 0 decimal places.

regards

brick