Displaying wide numbers in narrow Numbers columns without clipping

You can merge the cell with the one directly to the left of it. It would be best if it is a footer row. Note that the cell with the formula is actually in the column to the left, not the same column as the other numbers.

Or you can adjust the font size downward until it fits. Excel can do this automatically but you have to do it manually in Numbers.

You could coerce the Number to Text, something like this:

But then you can't use that cell for ongoing calculations and you have no (easy) way to control the thousands separator (the , or . used in your region).

Wouldn't it be easier to take advantage of the ability of Numbers to have multiple tables on one sheet and design your document so you have enough space to display the totals?

SG

The functionality is the same for long numbers. If you uncheck "Wrap text in cell" in the Text tab of the Format sidebar, the number will overflow to the adjacent cell: