Outreg2- how to format numbers in summary stats.

[Dimet Eco]

Hi,
I am trying to get detailed descriptive statistics for my data set. I use "outreg2" to export results into excel.

outreg2 if quarter==tq(2013q3) using sumstat5.xls, replace sum(detail) keep( $general )

(general is a global variable)
The problem is a numeric format in the summary table as some variables are displayed as exponential. It looks as below. How can I format these exponential values?

(2)	(3)
mean	sd
13.14	13.40
2.159e+08	4.396e+08
1.082e+08	2.071e+08
391475	1.474e+06
3.989e+07	1.069e+08
46067	168219
1.739e+07	6.062e+07
5.692	4.817
0.145	0.154
1.634	3.516

Thanks.

[Roberto Ferrer]

I don't use -outreg2- but I see in the -help- file there's a link to "5. Decimal places". Did you try that?

[Dimet Eco]

Roberto Ferrer Thanks for the response. Yes, I have tried that "5. Decimal places", but it didn't work out. The code and output are as seen above. I copied the list output below. The problem is with formatting these first two 9 digit numbers.


. list $general

+---------------------------------------------------+
| asset lnlsgr cr1 |
|-----------------------------------------------------|
1. | 777023309 401808394 .
2. | 779622540 407933509 10.05986 |
3. | 778987705 409443915 6.313115 |
4. | 788522565 422303723 8.608377 |
5. | 831394432 436050609 5.844569 |
|-----------------------------------------------------|

[Jana Schue]

Dimet Eco did you find a solution for this? I have the same problem