Formulas showing as text

[Dreamwine59]

Hello,
I am trying to link a form to a spreadsheet that will be used as an import into Access.
When I tried to create the form however, all my links are showing as Text and not the information that is in the linked cells. How do I get rid of this?
I am trying to set up some combofields on the form to make entry easier.
Here is what I am working with.


Thanks that worked, how I would have ever figured that out by myself is beyond me!!

[NBVC]

Select the entire sheet by clicking the grey intersection of columns/rows box at top left corner of spreadsheet and go To Edit|Replace and enter an = sign in both fields.

Click Replace All.

Then Ok.

Then, while sheet is still selected, go to Format|Cells and select General from the Number tab

[Dreamwine59]

thanks,
That worked great, I would have never figured it out by myself.