Data stored as text convert to values

[Leo Rod]

Good afternoon,

I have a column in a set of data formatted as text; is there any way to
convert this information to values? They're all numbers ending with ".0000
"-
No decimal values are into this data column.

I try eliminating the ".0000 " from all the values replacing it by "" but
it still text and I cannot make any operations with it.

Can I add a calculated column with the same set of data into values like in
excel with the function "Values()"??

Please let me know if you guys can think of any other solution for this
predicament.

Respectfully,

Leo-MIA, FL

 

[KARL DEWEY]

Val([YourTextfield])
OR
CLng([YourTextfield]) to convert to long integer.

There are other functions to convert to specific type of numbers.

 

[Leo Rod]

thanks!!!

Val([YourTextfield])
OR
CLng([YourTextfield]) to convert to long integer.

There are other functions to convert to specific type of numbers.

--
KARL DEWEY
Build a little - Test a little

Good afternoon,

I have a column in a set of data formatted as text; is there any way to
convert this information to values? They're all numbers ending with
".0000
"-
No decimal values are into this data column.

I try eliminating the ".0000 " from all the values replacing it by ""
but
it still text and I cannot make any operations with it.

Can I add a calculated column with the same set of data into values like
in
excel with the function "Values()"??

Please let me know if you guys can think of any other solution for this
predicament.

Respectfully,

Leo-MIA, FL