Ask Your Question

I am an old man (80) learning calc, it was working fine but suddenly stopped calculating. See details.

asked 2016-06-12 13:50:39 +0200

Nimijneb gravatar image

I am doing a personal budget, using currency figures (£). Columns B and C, C being totals for budget sections in B, entered fine. Then, fot my bottom line I entered a SUM calculation in column D and it would not take currency numerls, it hjust put ### into the cell. I have found that it now does this for further entries (tried experimentally) incolumns B & C, as well. What have I done wrong?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-06-12 14:14:18 +0200

timelord gravatar image

updated 2016-06-12 15:38:44 +0200

image description

This indicates the columns are too narrow to show the value.

All you need to do is increase the size of the columns and all should be well.

Hope you enjoy learning Calc.

edit flag offensive delete link more


Thank you very much. A satisfied old man, now.

Nimijneb gravatar imageNimijneb ( 2016-06-12 15:45:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-12 13:50:39 +0200

Seen: 64 times

Last updated: Jun 12 '16