Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc Currency ### Formatting

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?