Hello,
I have a dataset, it appears in Excel right like this

stkcd trdmnt msmvttl
000001 1991-12 2634210.72
000001 1992-12 5993999.81
000001 1993-12 6021490.04
000001 1994-12 4517599.33
000001 1995-12 3326125.61
000001 1996-12 17091009.31
000001 1997-12 35226928.99
000001 1998-12 23246669.44
000001 1999-12 27079731.76

When I copy it to Stata or import the Excel file it will be as shown below, in addition to the numbers are rounded if I convert it to Numeric, however, it is similar to Excel if it is listed as String.

stkcd trdmnt msmvttl
000001 1991-12 2,6e+06
000001 1992-12 6,0e+06
000001 1993-12 6,0e+06
000001 1994-12 4,5e+06
000001 1995-12 3,3e+06
000001 1996-12 1,7e+07
000001 1997-12 3,5e+07
000001 1998-12 2,3e+07
000001 1999-12 2,7e+07