Number Stored as text[RESOLVED]

[Mitch_s_s]

Hi as the title says, i have a number stored as text in a cell.
I know there must be a way to convert this to a number format, but when i format the cell to Number it does not convert.
There is the error message button, but when recording a macro it does not record this action.

I'd look in to this further, but it's the final piece of the code i need and it's pretty urgent.
Basic probably i know, but i;ve never come across it before.
I tried copying the value and storing it as a variable in vba
couldnt get Cint to work.

any help would be appreciated,
Thanks