Ask Your Question

Calc Currency ### Formatting

asked 2018-10-19 14:58:48 +0100

who8mypnuts gravatar image

I have a spreadsheet that I've been using for months. In one cell, whenever I put a number in and it's formatted as currency I get ### as the output. I have no idea why.

I can remove the currency formatting and it works just like any other cell. I can add formulas in and it works perfectly. But when I turn currency back on, immediately it turns into ###.

Does anyone have some insight as to why this is happening and what I can do to correct the issue?

edit retag flag offensive close merge delete


Thank you very much!!!

who8mypnuts gravatar imagewho8mypnuts ( 2018-10-19 15:11:02 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-10-19 15:10:46 +0100

who8mypnuts gravatar image

Thanks to the link Mike provided me with above I have an answer. "###


The cell is not wide enough to display the contents."

All I had to do was increase the width of the cell and it worked perfectly.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-19 14:58:48 +0100

Seen: 31 times

Last updated: Oct 19 '18