Formulas Not Computing

[Andre]

I have a speadsheet that I have been using for months
that contains several formulas.

All of a sudden, some of the formulas have stopped
computing. I have checked the formulas and they are
correct. They are simple formulas so I am somewhat
perplexed as to why they have stopped computing.

The two formulas are:

=J1-L1 and =J1*0.32

Both are computing a result of ######## after row 173,
yet the formulas appear correctly in the formula box in
row 173 and all subsequent rows.

I have tried reinserting the formulas without success.

I am not sure if there is a connection to recently having
downloaded the latest patch.

Is it possible for a speadsheet to become corrupted and,
if so, is there a way to repair it.

Thanks for any help/suggestions

 

[Frank Kabel]

Hi
any chance the columns are just not wide enough?

 

[Andre]

Hi Frank -

Thanks for your suggestion. Interestingly, the column
with remained the same down the entire speadsheet, but,
your thought led me to check the font size. For some
unknown reason, when I opened "format cells" after
highlighting the columns, no font size was highlighted.
When I re-selected 10, the problem resolved.

Thanks for solving my problem.