Ask Your Question
0

Calc Currency ### Formatting

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

who8mypnuts gravatar image

updated 2020-09-23 13:14:27 +0100

Alex Kemp 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

Comments

Thank you very much!!!

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

@mikeKaganski THANK YOU! I could not figure this out and it as extremely frustrating, I don't understand why the value doesn't just extend beyond the cell like text does, which would make it clear the cell is too small instead of looking like it's not calculating. Two years later, you saved my from pulling out what little hair I've left.

zijlstra gravatar imagezijlstra ( 2020-07-05 23:44:32 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

who8mypnuts gravatar image

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

none

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

Comments

THANK YOU! I could not figure this out and it as extremely frustrating, I don't understand why the value doesn't just extend beyond the cell like text does, which would make it clear the cell is too small instead of looking like it's not calculating. Two years later, you saved my from pulling out what little hair I've left.

zijlstra gravatar imagezijlstra ( 2020-07-05 23:44:14 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 520 times

Last updated: Oct 19 '18