Combo Box Number Formatting

[Simba1]

Hi Guys,

I can't seem to get around this tiny problem I'm having. I have a User Form with a Combo Box. The Combo Box has a Row Source pointing to a hidden sheet in my workbook. I want the user to have an option to enter his own selection in the Combo Box. Ideally it should be a number - and possibly a number with a decimal.

If I try entering in a 4.1 the decimal place does not appear - only 41 appears. Is this a common problem? Or have I missed entering something into its properties?

Thanks

 

[Simba1]

Forget it. I figured it out. My Match Entry should be none.