ExcelBanter - SUM cell shows only #####, worked before though. HELP???

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUM cell shows only #####, worked before though. HELP??? (https://www.excelbanter.com/excel-worksheet-functions/6814-sum-cell-shows-only-worked-before-though-help.html)

KimChiDahl

SUM cell shows only #####, worked before though. HELP???

I entered SUM formulas on a quarterly spreadsheet and until today all
worked. Now, only one is correct but the other 3 and the yearly total are
only showing ####### on the screen and when printed. I'm sure there is an
easy "duh" answer...I just don't know it. Is there a hero out there to save
me?

please respond to

Thank you,
Kim

Jason Morin

Widen the cell or shrink the font.

HTH
Jason
Atlanta, GA

-----Original Message-----
I entered SUM formulas on a quarterly spreadsheet and
until today all
worked. Now, only one is correct but the other 3 and
the yearly total are
only showing ####### on the screen and when printed.
I'm sure there is an
easy "duh" answer...I just don't know it. Is there a
hero out there to save
me?

please respond to

Thank you,
Kim
.

Frank Kabel

Hi
just widen the column :-)

--
Regards
Frank Kabel
Frankfurt, Germany

"KimChiDahl" schrieb im
Newsbeitrag ...
I entered SUM formulas on a quarterly spreadsheet and until today
all
worked. Now, only one is correct but the other 3 and the yearly
total are
only showing ####### on the screen and when printed. I'm sure there
is an
easy "duh" answer...I just don't know it. Is there a hero out there
to save
me?

please respond to

Thank you,
Kim

All times are GMT +1. The time now is 06:02 PM.