How to change Stata Settings to obtain full written-out results (not in e+ Form) even if resulting numbers are verly large

[Schwerdtfeger Rouven]

Hello everyone,

I am not sure if this problem was discussed under another topic, at least I couldn't find it. I would like to change my Stata settings so that very large results are no longer represented in the form of e.g., 1,74e+07 but just written out as a large number. I know it is perfectly possible to compare and read the e+- form of presentation but it doesn't come natural to me and makes interpretation more difficult. Also, when exporting results to excel, at least my Excel Version tends to interpret these results as string, I think due to the included letter.

Thank you very much for your help.
Kind regards
Rouven

[Marcos Almeida]

Welcome to the Stata Forum / Statalist.

Your query is strongly related to the - format - command.

[Rich Goldstein]

you don't say what results you want but using

help cformat

and looking at the other command shown there should cover most, at least, of what you are asking about; if these don't cover then please clarify your question

[Nick Cox]

If returned results are too large (or small) it may be a sign that you need to change units somewhere along the line.

[Schwerdtfeger Rouven]

Hallo Everyone, first let me thank you very much for the quick and helpful answer.
I checked the cformat and set the coefficent format to the maximum width. Now this doesn't seem to be enough as my coefficients are still written in the e+ Form.

Here is an example of my output that I am currently getting:

BrandID | sum
---------+----------
1 | 6.78e+07
2 | 1.72e+07
3 | 6.23e+07
4 | 1.37e+08
5 | 5.15e+07

So instead of 6.78e+07 I would like Stata to write out the number, i.e., 67,800,000.00! For my data this number is not unusually large (so I dont think its a unit problem) as I am dealing with dollar sales of huge brand portfolios and Blockbuster movie Sales for example can reach billions (espeacially if you sum the ump over time).
I tried to increase cformat but the maximum coefficient width is 9 apparently, which seems not to be enough for the representation of results which I would need. this problem also bothers me when numbers are getting really small, which can be the case for adspendings for example where every dollar only has an effect of a percentage of a cent.

Is there a way to increase the maximum coefficient width above 9?

Thank you very much,
It is apleasure to be part of this great community
Kind regards
Rouven

[Nick Cox]

Following #4 I recommend dividing by a million so that your units are million dollars. Beats anything else. You haven't made a case that seeing the cents too is interesting or useful.