convert big text number into only numbers

[Shaikh Aziz]

Dear Developers,

we have long text number's almost with 18 or 19 character with smart tags, we simply tried to convert it into only numbers but when we are converting it it's get changed last digits into "0000" only.

we want to convert long text number into only as it is in numbers.

please suggest any formula. also please find attached screenshot for your reference.
NOTE: we have total 3 workbooks with 30,000 rows in single column.
thankyou for looking it

 

[KOKOSEK]

You can't keep too big numbers as numbers.

 

[kweaver]

Although Excel can display 30 decimal places, its precision for a specified number is confined to 15 significant figures.

 

[Joe4]

Since these are just policy numbers (and not anything you would probably perform any mathematical computations on), is there some reason why they need to be converted to numbers and cannot just be left as Text?
By leaving them as Text, you will keep all significant digits.