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
Related Posts with How to avoid comma and rounding in numeric format
Interpreting results of npregress series (polynomial)- covariance structure for melogit model with random slopes
- Margins and standard errors with population data - vce(unconditional) or vce(delta)?
- Inserting value of a string in a filename when exporting
- Graph bar: two variables with the same categories in the same graph
Subscribe to:
Post Comments (Atom)
0 Response to How to avoid comma and rounding in numeric format
Post a Comment