Friday, March 3, 2023

changing numeric string to numeric variable where e5 next to a number means 10^5

I have a string variable of the type show below, where 63e5 represents 6300000. How do I change it 63e5 to its numeric form.

x
------------
0
1864071
NA
940268.89
22557529
0
63e5
NA
37631925
NA
8006659.83
0
NA
NA

No comments:

Post a Comment