Responses changing from number to text

Movaan I was working on a responses that has number stored as text, and, since I needed to do a calculation based on the responses (to utilized its data and save time from moving the responses to another worksheet) I would need to convert the number stored as text into a number or value for a calculation to work. 
So I tried using the CLEAN function as you had suggested, though it removes the unprintable character ( ' ), there's still a need to convert the results into a values manually.
I found this VALUE ie. =VALUE(text or cell) function which convert the number stored as text to value. This can also be a work around.
All the best.

Movaan While the issue can be resolved with the CLEAN formula, it is an extra step that should not be needed. The Form is setup with that field requiring a number and it should export into Excel as a number, like it used to. My problem still exists and requires the recalculations as my Excel data is being imported into an Access Database. When the number field remained a number this was not an issue.