Hi,

I can't seem to display results with 2 decimal using putexcel and the following option:
Code:
sysuse auto, clear
regress price mpg i.rep78
matrix b = e(b)
return list
ereturn list
summ price

putexcel set 0.Results.xlsx, sheet("test") modify
putexcel E4 = "`=(r(mean)*12)/sqrt(12)'", nformat("#.##")
*putexcel E4 = "`=(r(mean)*12)/sqrt(12)'", , nformat(number_d2)
I have tried to follow instructions here example 1 and 2:
https://blog.stata.com/2017/01/24/cr...a-expressions/

Can someone help me with the syntax? Thanks!