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?