The formula in this cell refers to a range that has additional numbers adjacent to it

Question

I can turn off this error warning in preferences, but Excel will still not allow me to sum some of these cells: enter image description here

Can't figure out why some rows work and others don't... driving me nuts! Help!

Answer 1

You need to increase the width of column J! ### means the value is too wide to display!

Numbers/dates that have too many digits to display in the given cell get replaced by hashes, but strings overflow or display as much as possible.