Converting numbers stored as text to numbers

[mando415]

Hi - looking for help here. I have tried to use the small green triangle to "convert to number" but this returns a scientific value stored as "general" format (from 350298922105792620 to 3.50299E+17). I have also tried multiplying by 1 but this seems to be rounding the value (350298922105792000).

Edit: As reference data type = 2; logical value. Hope this helps

Stumped and confused over here. Does anyone have any recommendations?

Thank you

 

[Kentetsu]

When I see something like this "3.50299E+17" the first thing I do is make sure the column width is big enough to display the entire number.

 

[mando415]

Yes - I should have mentioned I have tried this as well. No luck...