I have a combobox in sheet1 with a linked cell. When i select an entry from my dropdown (which is numbers 1-8), it changes the format on the linked cell to text. This means that my number is now stored as text.

This causes the vlookup function (which looks up the value in the linked cell to crash because it can't match text to a number)

Manually changing the format to "number" doesn't seem to work for me because as soon as i select a different entry from the dropdown, the format defaults back to "text".

Any ideas how i can stop this?

Thank you
Schwizer