SOLVED

Data in cells

Copper Contributor

I have used the formula fx =SUM and using currency. It has always worked but now instead of the totals I am getting this ####### where the numbers should be. I have gone back to home and chose currency Or tried numbers and still gives me the #######. I am using office 365 on my IPad. I am sure this is basic for many folks, sorry.

 

1 Reply
best response confirmed by allyreckerman (Microsoft)
Solution

@BFell270 

Did you try to increase the Column Width?

When column width is not enough to display the cell content, you will see # symbols in the cell.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@BFell270 

Did you try to increase the Column Width?

When column width is not enough to display the cell content, you will see # symbols in the cell.

View solution in original post