How To Get Sums In Total Boxes Instead Of Hash Signs - Libre Office

[Cantthinkof12use]

Hi, On some of my spread sheets on Libre Office, I have got hash signs instead of sums totals. How do I get the sums totals back? Thanks

[boxtops]

That happens if your columns are too narrow. Either make the column wider by dragging it, or reduce the size of the font for the total.

[SlackAlice]

At a guess, make the columns wider?

[aelmpvw]

increase the size of the cells

[Peter Pedant]

or change the format - £340 is bigger than 340

or click the 00-> 0 button (twice) and that converts 340.56 to 341 but still stores the more accurate number