######## Why do I see this in my cell that should contain a amoun

  • Thread starter Thread starter tous
  • Start date Start date
T

tous

I have created a spreadsheet with many formulas and one column is showing
####### in place of the amount as do the others. What does this symbol mean??
 
Without knowing the formula, all I can suggest is that maybe the column is
not wide enough to show the actual amount. Move your cursor to the column
numbers - A,B,C etc - between this column and the next. The pointer will
change to display a vertical line and left and right arrows. Doubleclik to
expand the width.
 
Usually this happens if the result of the formula is a larger number than the
column width. Expand the column width and see if that is truly the problem.
 
Back
Top